Re: [GENERAL] Determining scan types

[Sam Tregar]

On Tue, 3 Jul 2001, Philip Molter wrote:

> What causes this and how can I fix it?

Have you tried a VACUUM ANALYZE?  For some reason Postgres isn't able to
use its indexes fully unless you VACUUM ANALYZE often.

I consider this a bug but I gather the developers are OK with it.

-sam


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]