Hello all,
I have been playing around with the automated vacuum, but I can't seem to get it to perform as desired. My Situation: I have 15 or so databases that I am deleting all the data in them and re-importing on a nightly basis. (Long story here, but basically I found using the copy command was the fastest way to get the data into this read-only system from Sql Server 2000.) A couple of the databases are small and only take about 15 minutes to copy all the data, but others are much larger and take 45 minutes or more. So, I found that the databases run a lot faster if I perform a full vacuum on them. Duh! This got me to thinking I should set this up to automatically perform this vacuum each night after I got done with the import. Of course I then figured out that the built in automated vacuums were not based on time, they were more intelligently based on data change. I have been playing with different settings, but can't seem to get the databases to automatically backup. My Setup: Postgres 8.2 w\ postgis ext Windows Server 2003 Service Pack 2 My Settings: vacuum_cost_delay 20 enabled vacuum_cost_limit 200 disabled vacuum_cost_page_dirty 20 disabled vacuum_cost_page_hit 1 disabled vacuum_cost_page_miss 10 disabled autovacuum on enabled autovacuum_analyze_scale_factor 0.02 enabled autovacuum_analze_threshold 25 enabled autovacuum_freeze_max_age 200,000,000 enabled autovacuum_naptime 120min enabled autovacuum_vacuum_cost_delay 20 enabled autovacuum_vacuum_cost_limit 20 enabled autovacuum_vacuum_scale_factor 0.02 enabled autovacuum_vacuum_threshold 50 enabled My Question: Could someone point me to which settings I should be looking at (especially if not in the list above) that I should be changing to get this full vacuum to perform? Thanks in advance, Lee Keel
