Re: Index not used past a certain threshold - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Index not used past a certain threshold
Date
Msg-id 20389.1083298093@sss.pgh.pa.us
Whole thread Raw
In response to Index not used past a certain threshold  (Nishad Prakash <prakashn@uci.edu>)
List pgsql-bugs
Nishad Prakash <prakashn@uci.edu> writes:
> An index on a certain table is not being used if a column referenced in
> the query has more than a certain number of rows for a given value.

This is not a bug; it's intended and correct behavior.

You may have an issue that the crossover point isn't very well tuned for
your environment.  If so, the answer is to fool with the optimizer cost
parameters.  See the plgsql-performance archives...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Nishad Prakash
Date:
Subject: Index not used past a certain threshold
Next
From: Arturs Zoldners
Date:
Subject: Re: BUG #1142: Problem with update permissions for view