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(at)pervasive(dot)com>
To: "Martin Marques" <martin(at)bugs(dot)unl(dot)edu(dot)ar>; "frank church"
<pgsql(at)adontendev(dot)net>; <pgsql-sql(at)postgresql(dot)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(at)pervasive(dot)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
>
>