| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | ipv(at)tinet(dot)org |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Does VACUUM reorder tables on clustered indices |
| Date: | 2005-12-21 00:33:39 |
| Message-ID: | 20051221003339.GB72143@pervasive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
On Wed, Dec 21, 2005 at 12:34:12AM +0100, ipv(at)tinet(dot)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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-12-21 04:47:24 | I am back online again |
| Previous Message | ipv | 2005-12-20 23:34:12 | Re: Does VACUUM reorder tables on clustered indices |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-12-21 09:34:32 | Re: Help me do a LOOP |
| Previous Message | William Lai | 2005-12-20 23:53:57 | unsubscribe |