|
> Do you have autovacuum turned on? With what settings? Yes, I have it turned on. The settings are: autovacuum on autovacuum_analyze_scale_factor 0.1 autovacuum_analyze_threshold 250 autovacuum_freeze_max_age 200000000 autovacuum_naptime 1min autovacuum_vacuum_cost_delay -1 autovacuum_vacuum_cost_limit -1 autovacuum_vacuum_scale_factor 0.2 autovacuum_vacuum_threshold 500 vacuum_cost_delay 0 vacuum_cost_limit 200 vacuum_cost_page_dirty 20 vacuum_cost_page_hit 1 vacuum_cost_page_miss 10 vacuum_freeze_min_age 100000000 > Do you run scheduled VACUUM ANALYZE? This too, every night. > What does the tail of the output from your last > VACUUM ANALYZE VERBOSE look like? I'll try to look it up and post it back here once I got it. Express yourself instantly with MSN Messenger! MSN Messenger |
