On Feb 4, 2008, at 10:00 AM, Wes wrote:
Just a follow-up on this... The REINDEX took about 2 1/2 days. I
didn't
gain much disk space back - a full backup takes just as long as
before, but
the vacuum time dropped from 30 hours to 3 hours.
what you need to do is compare the relpages from the pg_class table
for that index before and after.
if you didn't get much disk space back, make sure you have no long
running transactions that may have kept some older files open.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
