From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Auto Vacuum question? |
Date: | 2007-06-05 12:47:12 |
Message-ID: | 20070605124712.GA3859@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Charles.Hou wrote:
> On 6 4 , 10 49 , alvhe(dot)(dot)(dot)(at)commandprompt(dot)com (Alvaro Herrera) wrote:
> > It is normal that the tables grow a bit to a stationary state of dead
> > space (generated by UPDATE and DELETE). However it is not normal if it
> > loses track of that dead space. One thing you can and should do is
> > adjust the autovacuum settings (for example lowering the vacuum scale
> > factor and threshold values). Another is to correctly set the FSM
> > values.
> autovacuum_vacuum_scale_factor = 1 # fraction of rel size before
> autovacuum_analyze_scale_factor = 1 # fraction of rel size before
These values are rather strange; they mean it would wait until the table
is populated by as many dead tuples as there are live tuples, before
vacuuming it. This is probably too much. Try decreasing the vacuum
scale factor to 0.2 or maybe 0.1 and see how it goes.
--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)
From | Date | Subject | |
---|---|---|---|
Next Message | Chander Ganesan | 2007-06-05 13:12:21 | Re: the right time to vacuum database? |
Previous Message | Charles.Hou | 2007-06-05 10:33:09 | the right time to vacuum database? |