Re: Vacuum non-clustered tables only

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