SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 06:38 AM
| ||||
| ||||
 autovacuum ignore tables Hi Is it possible to tell autovacuum to ignore certain tables (These tables are high traffic daily partition tables that get dropped every other day). I am trying to get autovacuum to complete quicker and prevent Xactn wraparound (currently, it takes very long and due to the fact that I have to restart the database for maintenance purposes), autovacuum never finishes.)      |
|
04-10-2008, 06:38 AM
| |||
| |||
| Re: autovacuum ignore tables "Sriram Dandapani" <sdandapani@counterpane.com> writes: > I am trying to get autovacuum to complete quicker and prevent Xactn > wraparound (currently, it takes very long and due to the fact that I > have to restart the database for maintenance purposes), autovacuum never > finishes.) Why are you restarting the database? There is no "maintenance purpose" I'm aware of that requires routine postmaster restarts. As for suppressing autovac on specific tables, see the pg_autovacuum system catalog. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
|
04-10-2008, 06:39 AM
| ||||
| ||||
| Re: autovacuum ignore tables Sriram Dandapani wrote: > > Hi > > > > Is it possible to tell autovacuum to ignore certain tables (These > tables are high traffic daily partition tables that get dropped every > other day). > > > > I am trying to get autovacuum to complete quicker and prevent Xactn > wraparound (currently, it takes very long and due to the fact that I > have to restart the database for maintenance purposes), autovacuum > never finishes.) > If you are running PostgreSQL 8.1 with integrated autovacuum, then yes, you can disable autovacuum on a per table basis, if you are using an older version with the contrib autovacuum, then no. Matt ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
 |
« When vaccuum full should be performed with postgresql-8.1 and autovaccuum?
|
Re: Installing Postgres 8.1 as a service pn Windows only »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:56 AM.
