On Jan 23, 2008 12:29 PM, Thomas Lozza <thomas.lozza@xxxxxxxxxxxxxxxx> wrote: > Auto vacuum is enabled. Here are the settings: > > autovacuum = true > autovacuum_naptime = 900 > autovacuum_vacuum_threshold = 2000 > autovacuum_analyze_threshold = 1000 > autovacuum_vacuum_scale_factor = 0.25 > autovacuum_analyze_scale_factor = 0.18 > autovacuum_vacuum_cost_delay = 150 > autovacuum_vacuum_cost_limit = 120 > > A manual vacuum takes very long (around 4 days), so maybe the cost delay > and limit or too high. Your autovacuum_vacuum_cost_delay is REALLY high. Try setting it to 10 or 20 and see if that helps. What is your plain old vacuum_cost_delay set to? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
