| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
| Cc: | Chris Velevitch <chris(dot)velevitch(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Which indexes does a query use? |
| Date: | 2006-02-27 00:36:19 |
| Message-ID: | 4400.1141000579@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Russell Smith <mr-russ(at)pws(dot)com(dot)au> writes:
> Chris Velevitch wrote:
>> If I'm reading this right, it's telling me that is NOT using any indexes.
>> Clearly, this is wrong.
> Not necessarily.
> ...
> If you post "explain analyze" instead of "explain" and possibly the
> number row in that table, we might be able to help further, but that is
> my best guess from the information given.
Also, has the table been vacuumed/analyzed lately? The planner clearly
thinks it is small, but that information could be out of date (and 7.x
releases aren't going to notice if the table has gotten bigger since
the last vacuum or analyze).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Velevitch | 2006-02-27 00:57:40 | Fwd: Which indexes does a query use? |
| Previous Message | Bruce Momjian | 2006-02-27 00:22:07 | Re: How much clustered? |