Re: Vacuums taking forever :(

On Tue, Feb 3, 2009 at 9:09 PM, Andreas Wenk
<a(dot)wenk(at)netzmeister-st-pauli(dot)de> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Phoenix Kiula schrieb:
>> In my conf_pg, the autovacuum is on, so the DB should be (or I hope is
>> being) regularly vacuumed.
>>
>> These are my settings:
>>
>>
>> work_mem = 20MB
>> temp_buffers = 4096
>> authentication_timeout = 10s
>> ssl = off
>> checkpoint_warning = 3600
>> random_page_cost = 1
>> autovacuum = on
>> autovacuum_vacuum_cost_delay = 20
>> vacuum_cost_delay = 20
>> autovacuum_naptime = 10
>> stats_start_collector = on
>> stats_row_level = on
>> autovacuum_vacuum_threshold = 75
>> autovacuum_analyze_threshold = 25
>> autovacuum_analyze_scale_factor = 0.02
>> autovacuum_vacuum_scale_factor = 0.01
>>
>
> Hi ,
>
> just a quick thought. What is your maintenance_work_mem parameter set to? I think with
> that lot Updates and Inserts this should not be too low ...

maintenance_work_mem = 512M
wal_buffers = 64
checkpoint_segments = 128
checkpoint_timeout = 900
fsync = on

Is this enough? My server has 4GB RAM.