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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to