Re: Vacuum and FSM page size

On Jan 23, 2008 12:29 PM, Thomas Lozza  wrote:
> Auto vacuum is enabled. Here are the settings:
>
> autovacuum = true
> autovacuum_naptime = 900
> autovacuum_vacuum_threshold = 2000
> autovacuum_analyze_threshold = 1000
> autovacuum_vacuum_scale_factor = 0.25
> autovacuum_analyze_scale_factor = 0.18
> autovacuum_vacuum_cost_delay = 150
> autovacuum_vacuum_cost_limit = 120
>
> A manual vacuum takes very long (around 4 days), so maybe the cost delay
> and limit or too high.

Your autovacuum_vacuum_cost_delay is REALLY high.  Try setting it to
10 or 20 and see if that helps.

What is your plain old vacuum_cost_delay set to?