Re: Vacuums taking forever :(

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Phoenix Kiula schrieb:
> 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.
>

Try to increase it but check also what Andrew wrote in the other reply. Maybe ther is the
problem ...

Cheers

Andy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJiEz4Va7znmSP9AwRAsD8AKC4+98SzjKfi4YLgAQ1697rr2DgpgCg3oXH
PMYe+Y3OJf3YnisJ/rU2REI=
=d7/G
-----END PGP SIGNATURE-----