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
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:06 AM, 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
On Wed, May 14, 2014 at 3:45 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Wed, May 14, 2014 at 12:06 AM, 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