| 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: | 2006-09-27 16:13:44 |
| Message-ID: | 1159373624.3874.187.camel@coppola.muc.ecircle.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-09-27 16:14:54 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Previous Message | Tobias Brox | 2006-09-27 16:13:29 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2006-09-27 16:14:54 | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Previous Message | Tobias Brox | 2006-09-27 16:13:29 | Re: [PERFORM] autovacuum on a -mostly- r/o table |