| 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: | Whole Thread | Raw Message | 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/
| 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 |