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: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
- To: Edoardo Ceccarelli <eddy(at)axa(dot)it>
- Cc: 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 18:13:44 +0200
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.
- Follow-Ups:
- Re: [PERFORM] autovacuum on a -mostly- r/o table
- From: Matthew T. O'Connor
- Re: [PERFORM] autovacuum on a -mostly- r/o table
- References:
- autovacuum on a -mostly- r/o table
- From: Edoardo Ceccarelli
- autovacuum on a -mostly- r/o table
- Prev by Date: Re: [PERFORM] autovacuum on a -mostly- r/o table
- Next by Date: Re: [PERFORM] autovacuum on a -mostly- r/o table
- 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: