Re: Vacuum and FSM page size - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Vacuum and FSM page size
Date
Msg-id dcc563d10801240748m3a2a3309r983a5087ebb17186@mail.gmail.com
Whole thread Raw
In response to Vacuum and FSM page size  ("Thomas Lozza" <thomas.lozza@nexustelecom.com>)
Responses Re: Vacuum and FSM page size  ("Thomas Lozza" <thomas.lozza@nexustelecom.com>)
List pgsql-performance
On Jan 23, 2008 12:29 PM, Thomas Lozza <thomas.lozza@nexustelecom.com> 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?

pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: Making the most of memory?
Next
From: Chris Browne
Date:
Subject: Re: Making the most of memory?