Lonni J Friedman <netllama@gmail.com> 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