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 <rumman...@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. > >