Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [PERFORM] autovacuum on a -mostly- r/o table
- From: "Matthew T. O'Connor" <matthew(at)zeut(dot)net>
- To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
- Cc: Edoardo Ceccarelli <eddy(at)axa(dot)it>, postgres performance list <pgsql-performance(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Date: Wed, 27 Sep 2006 14:33:10 -0400
Csaba Nagy wrote:
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.
In addition autovacuum respects the work of manual or cron based vacuums, so if you issue a vacuum right after a daily batch insert / update, autovacuum won't repeat the work of that manual vacuum.
- References:
- autovacuum on a -mostly- r/o table
- From: Edoardo Ceccarelli
- Re: [PERFORM] autovacuum on a -mostly- r/o table
- From: Csaba Nagy
- autovacuum on a -mostly- r/o table
- Prev by Date: Re: having trouble restoring a database from files
- Next by Date: How can I restore from WAL log? [PG 7.3]
- Previous by thread: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Next by thread: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Indexes: