From: | "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | tuning auto vacuum for highly active tables |
Date: | 2010-03-23 20:54:37 |
Message-ID: | C84662912D280D4AB5C50100A100F0C50574C753@ct11exm61.ds.mot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
Hi All,
We have a postgres database in which couple of tables get bloated due to
heavy inserts and deletes. Auto vacuum is running. My question is how
can I make auto vacuum more aggressive? I am thinking of enabling
autovacuum_vacuum_cost_delay and autovacuum_vacuum_cost_limit
parameters. Can anyone suggest how to calculate the appropriate values
for these parameters and if there are any side effects of enabling these
parameters. Any help will be highly appreciated.
Thanks
Paramjeet Kaur
From | Date | Subject | |
---|---|---|---|
Next Message | Szu-Ching Peckner | 2010-03-23 21:35:45 | Re: tuning auto vacuum for highly active tables |
Previous Message | Tom Lane | 2010-03-23 16:26:46 | Re: Disparity between 8.1.18 and 8.2.14 performance wise |
From | Date | Subject | |
---|---|---|---|
Next Message | Eliot Gable | 2010-03-23 21:00:23 | Performance Tuning Large PL/PGSQL Stored Procedure |
Previous Message | Scott Marlowe | 2010-03-23 20:10:03 | Re: mysql to postgresql, performance questions |