Postgres Pro
Downloads
Home   >   mailing lists

Re: "vacuum" and "cluster" - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: "vacuum" and "cluster"
Date
Msg-id 20080416160619.GB5288@alvh.no-ip.org
Whole thread Raw
In response to Re: "vacuum" and "cluster"  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: "vacuum" and "cluster"  ("Jimmy Choi" <yhjchoi@gmail.com>)
List pgsql-general
Tree view 
Craig Ringer escribió:

> It's not stated explicitly, but I'm pretty sure discussion here has
> mentioned that too. Given that, VACUUM FULL on a just-CLUSTERed table
> should be redundant.

It is, and a REINDEX is redundant too because CLUSTER does it
internally.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Vance Maverick"
Date:
Subject: table as log (multiple writers and readers)
Next
From: brian
Date:
Subject: Re: table as log (multiple writers and readers)