Postgres Pro
Downloads
Home   >   mailing lists

Re: what should be the best autovacuum configuration for daily partition table - Mailing list pgsql-general

From chiru r
Subject Re: what should be the best autovacuum configuration for daily partition table
Date
Msg-id CA+RSxMiAmYk5_H1p8rd0CtbQke-DXwfrdigfw_az0s1A7zD_cw@mail.gmail.com
Whole thread Raw
In response to what should be the best autovacuum configuration for daily partition table  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view
Hi Rumman,

Please publish the below information.

1. vacuum and auto-vacuum parametters current settings on cluster.
     select name,setting from pg_settings where name ilike '%vacuum%';

2.  show maintenance_work_mem ;
     show autovacuum_max_workers ;

3. Physical Ram size on server.
     
--Chiru


On Wed, May 14, 2014 at 12:36 PM, AI Rumman <rummandba@gmail.com> wrote:
Hi,

I have a table with daily partition setup where old partitions are static tables that is after each day we don't get any new data in old partitions.
The database size is 2 TB and I am running with autovacuum on for Postgresql 8.4.
Now, I am facing a problem where old tables are not being vacuumed by autovacuum deamon and every now and then we are seeing autovacuum to prevent wrap around in the database and age(datfrozenzid) gets high for the database.
Any idea what should be best configuration for this type of database environment.

Thanks.


pgsql-general by date:

Previous
From: Stephan Fabel
Date:
Subject: Re: LDAP authentication not working
Next
From: Jeff Janes
Date:
Subject: Re: what should be the best autovacuum configuration for daily partition table