Re: VACUUM ANALYZE downgrades performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE downgrades performance
Date: 2004-12-02 16:30:44
Message-ID: 20041202163044.GA30522@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2004-12-02 16:38:57 Re: VACUUM ANALYZE downgrades performance
Previous Message Rod Taylor 2004-12-02 16:25:18 Re: VACUUM ANALYZE downgrades performance