From: | <ipv(at)tinet(dot)org> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Does VACUUM reorder tables on clustered indices |
Date: | 2005-12-20 23:34:12 |
Message-ID: | 00e001c605bd$e23ca1a0$0600000a@d505 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-12-21 00:33:39 | Re: Does VACUUM reorder tables on clustered indices |
Previous Message | Tom Lane | 2005-12-20 23:13:15 | Re: localization problem (and solution) |
From | Date | Subject | |
---|---|---|---|
Next Message | William Lai | 2005-12-20 23:53:57 | unsubscribe |
Previous Message | Tom Lane | 2005-12-20 23:31:15 | Re: Performance of a view |