Total RAM in the system is 2GB #----------------------------------------------------------------------- ---- # AUTOVACUUM PARAMETERS #----------------------------------------------------------------------- ---- vacuum_cost_delay = 200 # 0-1000 milliseconds vacuum_cost_page_hit = 1 # 0-10000 credits vacuum_cost_page_miss = 10 # 0-10000 credits vacuum_cost_page_dirty = 20 # 0-10000 credits vacuum_cost_limit = 200 # 0-10000 credits autovacuum = on autovacuum_naptime = 3600 #autovacuum_vacuum_threshold = 1000 #autovacuum_analyze_threshold = 500 #autovacuum_vacuum_scale_factor = 0.4 #autovacuum_analyze_scale_factor = 0.2 #autovacuum_vacuum_cost_delay = -1 #autovacuum_vacuum_cost_limit = -1 Some other parameter max_connections = 350 shared_buffers = 400MB # set to 16 MB min 16 or max_connections*2, 8KB each temp_buffers = 8MB # min 100, 8KB each max_prepared_transactions = 5 # can be 0 or more work_mem = 4MB # min 64, size in KB maintenance_work_mem = 256MB # min 1024, size in KB max_stack_depth = 2048 # min 100, size in KB max_fsm_pages = 2000000 # min max_fsm_relations*16, 6 bytes each max_fsm_relations = 1000 # min 100, ~70 bytes each max_files_per_process = 1000 # min 25 bgwriter_delay = 200 # 10-10000 milliseconds between rounds bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned/round bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round Regards Sachchida -----Original Message----- From: Michael Glaesemann [mailto:grzm@xxxxxxxxxxxxxxx] Sent: Tuesday, August 21, 2007 5:36 PM To: Sachchida Ojha Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Autovacuum is running forever On Aug 21, 2007, at 16:26 , Sachchida Ojha wrote: > In my OLTP system, we are inserting, updating and deleting the data > every second. > > Autovacuum started and never finished slowing down the whole system. There's the possibility that your autovacuum settings aren't aggressive enough for your system, so it's never able to catch up. Without knowing details it's hard to say for certain. What are your autovacuum settings and other details about the load on your system? Michael Glaesemann grzm seespotcode net ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
