On Feb 12, 2008, at 9:13 AM, Thomas Chille wrote:
vacuum_cost_delay = 200 vacuum_cost_page_hit = 6 vacuum_cost_limit = 100
Vacuum is going to take forever with those settings. I strongly suggest you set them back to default. If you need to throttle vacuum, try setting cost_delay to between 10 and 20.
-- Decibel!, aka Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828
<<attachment: smime.p7s>>