Re: Slow after VACUUM, fast after DROP-CREATE INDEX

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Scott Marlowe <smarlowe(at)qwest(dot)net>
Subject: Re: Slow after VACUUM, fast after DROP-CREATE INDEX
Date: 2004-08-06 23:14:18
Message-ID: 411410CA.9070605@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe wrote:
> Unfortunately, the administrative overhead in 7.1.3 is noticeably higher
> than it is in 7.4. The overhead should be lowered even more in 8.0 with
> the integration of the autovacuum daemon into the backend process.

May be the autovacuum will be integrated in the version 8.1 and not in the
version 8.0. However the pg_autovacuum is not enough, I suggest at least
once a day perform a vacuum full and a reindex for tables eavily updated.

Regards
Gaetano Mendola

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gaetano Mendola 2004-08-06 23:16:17 Re: Postgres and Tools Intro?
Previous Message Gaetano Mendola 2004-08-06 23:09:47 Re: probelm migrating from 7.3.4 to 7.42