Eternal vacuuming....

I checked the changelog for 7.0 and it doesn't look like this is fixed
yet.

In 6.4.x and 6.5.x if you delete a large number of rows (say 100,000 -
1,000,000) then hit vacuum, the vacuum will run literally forever.

If you drop the indexes on the table, vacuuming takes only minutes, but
that's a pain in the neck.

This problem kept my site down for some 12 HOURS last nite:

24244 ?        S      0:00 psql db_gotocity
24245 ?        R    951:34 /usr/local/pgsql/bin/postgres localhost tim
db_gotocity 

...before I finally killed the vacuum process, manually removed the
pg_vlock, dropped the indexes, then vacuumed again, and re-indexed.

Will this be fixed?

Tim

-- 
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723