Lonni J Friedman <[EMAIL PROTECTED]> writes:
> Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
CLUSTER is frequently a competitive alternative to VACUUM FULL.
In 8.0, there are some flavors of ALTER TABLE that rewrite the whole
table; this would work too, and should be faster than CLUSTER if you
don't care about the resulting table order.
Neither of these are a good substitute for plain VACUUM, but when you
have a table that's sparse enough to need a VACUUM FULL, consider them.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
