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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
