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

From Alvaro Herrera
Subject Re: "vacuum" and "cluster"
Date
Msg-id 20080416192733.GC7942@alvh.no-ip.org
Whole thread Raw
In response to Re: "vacuum" and "cluster"  ("Jimmy Choi" <yhjchoi@gmail.com>)
List pgsql-general
Jimmy Choi escribió:
> Presumably, even if CLUSTER does reindexing internally, it only does
> that for the index used for clustering. Since REINDEX includes all
> indices, CLUSTER cannot truly replace REINDEX. Correct?

No.  Cluster rewrites all indexes (otherwise their entries would end up
pointing to incorrect places in the heap.)

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

pgsql-general by date:

Previous
From: "David Wilson"
Date:
Subject: Re: table as log (multiple writers and readers)
Next
From: Karsten Hilbert
Date:
Subject: Re: Storage sizes for dates/times (documentation bug?)