| 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
| 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 |