Re: Vacuum settings

dforums wrote:
> Hello,
>
> I need wo advice on vacuum settings.
>
> I have a quad core X5355 @ 2.66GHz with 8 Go of memory
>
> 1Q) Why autovaccum does not work, I have set the value to on in
> postgresql.conf but when the server start it's still off !!!!

You need to turn stats_row_level on too.

> # - Cost-Based Vacuum Delay -
>
> vacuum_cost_delay = 5 # 0-1000 milliseconds
> vacuum_cost_page_hit = 1000 # 0-10000 credits
> vacuum_cost_page_miss = 1000 # 0-10000 credits
> vacuum_cost_page_dirty = 120 # 0-10000 credits
> vacuum_cost_limit = 20 # 0-10000 credits

The cost are all too high and the limit too low. I suggest resetting to
the default values, and figuring out a reasonable delay limit (your
current 5ms value seems a bit too low, but I think in most cases 10ms is
the practical limit due to sleep granularity in the kernel. In any
case, since the other values are all wrong I suggest just setting it to
10ms and seeing what happens).

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support