X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 8EDDA9DCB13
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 20 Dec 2005 19:41:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 86572-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 20 Dec 2005 19:41:43 -0400 (AST)
X-Greylist: delayed 00:06:38.683597 by SQLgrey-
Received: from mail.tinet.org (mail.tinet.org [195.77.216.130])
	by postgresql.org (Postfix) with ESMTP id 63F599DCB0D
	for <pgsql-sql@postgresql.org>; Tue, 20 Dec 2005 19:41:38 -0400 (AST)
Received: (qmail 24508 invoked from network); 20 Dec 2005 23:34:59 -0000
Received: from 224.red-83-36-187.dynamicip.rima-tde.net (HELO d505)
	(ipv@[83.36.187.224]) (envelope-sender <ipv@tinet.org>)
	by mail.tinet.org (qmail-ldap-1.03) with SMTP
	for <pgsql-sql@postgresql.org>; 20 Dec 2005 23:34:59 -0000
Message-ID: <00e001c605bd$e23ca1a0$0600000a@d505>
Reply-To: <ipv@tinet.org>
From: <ipv@tinet.org>
To: <pgsql-sql@postgresql.org>
References: <1134940325.43a5d0a5a882e@webmail.adontendev.net>
	<Pine.LNX.4.61.0512181840350.20029@bugs.unl.edu.ar>
	<20051218220139.GA1651@surnet.cl>
	<20051220214124.GR28771@pervasive.com>
Subject: Re: Does VACUUM reorder tables on clustered indices
Date: Wed, 21 Dec 2005 00:34:12 +0100
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.55 required=5 tests=[NO_REAL_NAME=0.55]
X-Spam-Score: 0.55
X-Spam-Level: 
X-Archive-Number: 200512/182
X-Sequence-Number: 23724

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
>
>