Re: Does VACUUM reorder tables on clustered indices

Hi,

Utilize <b>CLUSTER;</b> (after vacuum) to reorder the data.

Regards


----- Original Message ----- 
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: "Martin Marques" <martin@bugs.unl.edu.ar>; "frank church" 
<pgsql@adontendev.net>; <pgsql-sql@postgresql.org>
Sent: Tuesday, December 20, 2005 10:41 PM
Subject: Re: [SQL] Does VACUUM reorder tables on clustered indices


> On Sun, Dec 18, 2005 at 07:01:39PM -0300, Alvaro Herrera wrote:
>> Martin Marques escribi?:
>> > On Sun, 18 Dec 2005, frank church wrote:
>> >
>> > >
>> > >Does VACUUMing reorder tables on clustered indices or is it only the
>> > >CLUSTER
>> > >command that can do that?
>> >
>> > Cluster does that. Vacuum only cleans dead tuples from the tables.
>>
>> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>