Postgres Pro
Downloads
Home   >   mailing lists

Re: Does VACUUM reorder tables on clustered indices - Mailing list pgsql-sql

From Jim C. Nasby
Subject Re: Does VACUUM reorder tables on clustered indices
Date
Msg-id 20051221003339.GB72143@pervasive.com
Whole thread Raw
In response to Re: Does VACUUM reorder tables on clustered indices  (<ipv@tinet.org>)
List pgsql-sql
Tree view 
On Wed, Dec 21, 2005 at 12:34:12AM +0100, ipv@tinet.org wrote:
> Hi,
> 
> Utilize <b>CLUSTER;</b> (after vacuum) to reorder the data.

Why would you vacuum when cluster is just going to wipe out the dead
tuples anyway?

> >>Note that while reordering, CLUSTER also gets rid of dead tuples, so if
> >>you cluster you don't need to vacuum.
> >
> >It also does a REINDEX...
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-sql by date:

Previous
From: William Lai
Date:
Subject: unsubscribe
Next
From: Calin Meze
Date:
Subject: Help me do a LOOP