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