Patrick,
> Answered my own question. I gave up the vacuum full after 150 mins. I was
> able to export to a file, vacuum full the empty table, and reimport in less
> than 10 mins. I suspect the empty item pointers and the sheer number of
> removable rows was causing an issue.
Yeah. If you've a table that's not been vacuumed in a month, it's often
faster to clean it out and import it.
I've seen vacuums take up to 3 hours in really bad cases.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
