Re: Slow after VACUUM, fast after DROP-CREATE INDEX - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: Slow after VACUUM, fast after DROP-CREATE INDEX
Date
Msg-id 411410CA.9070605@bigfoot.com
Whole thread Raw
In response to Re: Slow after VACUUM, fast after DROP-CREATE INDEX  ("Scott Marlowe" <smarlowe@qwest.net>)
List 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

pgsql-general by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: probelm migrating from 7.3.4 to 7.42
Next
From: Gaetano Mendola
Date:
Subject: Re: Postgres and Tools Intro?