Reiner Dassing <dassing@wettzell.ifag.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