Glen Parker wrote:
I think I know the answer to this, but...
Is there a semi-easy way vacuum all tables in a database *except* those
that are clustered?
(VACUUM [full]; CLUSTER;) is a huge waste of time and resources when you
have clustered tables. If there isn't a way to do this, can we consider
it a feature request?
Perhaps "VACUUM unclustered" or something?
A couple of thoughts:
1. You shouldn't routinely be running VACUUM FULL on a recent installation.
2. Autovacuum should effectively do this, assuming the clustered table
isn't being updated.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
