Re: Index not used past a certain threshold

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nishad(at)ptolemy(dot)tlg(dot)uci(dot)edu
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Index not used past a certain threshold
Date: 2004-04-30 04:08:13
Message-ID: 20389.1083298093@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Nishad Prakash <prakashn(at)uci(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Arturs Zoldners 2004-04-30 09:36:07 Re: BUG #1142: Problem with update permissions for view
Previous Message Nishad Prakash 2004-04-30 01:51:42 Index not used past a certain threshold