| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Index of a table is not used (in any case) |
| Date: | 2001-10-23 04:00:24 |
| Message-ID: | m3d73fhup3.fsf@belphigor.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de> writes:
> Hello PostgreSQl Users!
>
> PostSQL V 7.1.1:
>
> I have defined a table and the necessary indices.
> But the index is not used in every SELECT. (Therefore, the selects are
> *very* slow, due to seq scan on
> 20 million entries, which is a test setup up to now)
Perennial first question: did you VACUUM ANALYZE?
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2001-10-23 04:08:14 | Re: [HACKERS] Index of a table is not used (in any case) |
| Previous Message | Lamar Owen | 2001-10-23 03:56:24 | Re: [GENERAL] To Postgres Devs : Wouldn't changing the selectlimit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2001-10-23 04:08:14 | Re: [HACKERS] Index of a table is not used (in any case) |
| Previous Message | Stephan Szabo | 2001-10-23 02:17:08 | Re: cast |