Re: [PERFORM] autovacuum on a -mostly- r/o table - Mailing list pgsql-admin

From Csaba Nagy
Subject Re: [PERFORM] autovacuum on a -mostly- r/o table
Date
Msg-id 1159373624.3874.187.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to autovacuum on a -mostly- r/o table  (Edoardo Ceccarelli <eddy@axa.it>)
Responses Re: [PERFORM] autovacuum on a -mostly- r/o table  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-admin
On Wed, 2006-09-27 at 18:08, Edoardo Ceccarelli wrote:
> How can I configure the vacuum to run after the daily batch insert/update?

Check out this:
http://www.postgresql.org/docs/8.1/static/catalog-pg-autovacuum.html

By inserting the right row you can disable autovacuum to vacuum your big
tables, and then you can schedule vacuum nightly for those just as
before. There's still a benefit in that you don't need to care about
vacuuming the rest of the tables, which will be done just in time.

Cheers,
Csaba.


pgsql-admin by date:

Previous
From: Tobias Brox
Date:
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Next
From: Bill Moran
Date:
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table