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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance