Re: VACUUM ANALYZE downgrades performance

On Thu, Dec 02, 2004 at 05:07:17PM +0100, Dmitry Karasik wrote:
> While I agree that generally this is true, look how stupid this
> behavior looks in this particular case: A developer creates a table
> and index, knowing that the table will be large and will be intensively
> used. An admin runs 'VACUUM ANALYZE' when table is occasionally empty,
> and next, say, 1 day, until another 'VACUUM ANALYZE' starts, the index
> is simply not used! Sure you don't suppose to run 'VACUUM ANALYZE' every
> 5 minutes as a solution, right?

No, you run autovacuum, which automatically re-analyzes at approximately the
right time.

/* Steinar */
--
Homepage: http://www.sesse.net/