From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | dforums <dforums(at)vieonet(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Vacuum settings |
Date: | 2008-04-21 15:03:37 |
Message-ID: | 20080421150336.GJ6520@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Cottenceau | 2008-04-21 15:31:03 | Re: Vacuum settings |
Previous Message | Erik Jones | 2008-04-21 14:46:17 | Re: connections slowing everything down? |