Postgres Pro
Downloads
Home   >   mailing lists

Re: Determining scan types - Mailing list pgsql-general

From Sam Tregar
Subject Re: Determining scan types
Date
Msg-id Pine.LNX.4.30.0107031041140.11297-100000@localhost.localdomain
Whole thread Raw
In response to Determining scan types  (Philip Molter <philip@datafoundry.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Philip Molter
Date:
Subject: Re: Determining scan types
Next
From: Tom Lane
Date:
Subject: Re: Regression