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.wenk@netzmeister-st-pauli.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-----