Quick Links

Vacuum non-clustered tables only

From:	Glen Parker <glenebob(at)nwlink(dot)com>
To:	Postgres General <pgsql-general(at)postgresql(dot)org>
Subject:	Vacuum non-clustered tables only
Date:	2007-05-16 22:40:27
Message-ID:	464B885B.7040803@nwlink.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

-Glen

Responses

Re: Vacuum non-clustered tables only at 2007-05-16 23:41:45 from Joshua D. Drake
Re: Vacuum non-clustered tables only at 2007-05-17 03:02:55 from Jim C. Nasby
Re: Vacuum non-clustered tables only at 2007-05-17 06:10:56 from Richard Huxton
Re: Vacuum non-clustered tables only at 2007-05-17 21:43:23 from Reece Hart

Browse pgsql-general by date

	From	Date	Subject
Next Message	Joshua D. Drake	2007-05-16 23:41:45	Re: Vacuum non-clustered tables only
Previous Message	Richard Huxton	2007-05-16 22:38:48	Re: Constructing a SELECT statement in pl/pgsql