-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Phoenix Kiula schrieb: > On Tue, Feb 3, 2009 at 9:09 PM, Andreas Wenk > <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general