Postgres Pro
Downloads
Home   >   mailing lists

Re: Which Order Vacuum Full Analyze Cluster Reindex? - Mailing list pgsql-general

From Greg Stark
Subject Re: Which Order Vacuum Full Analyze Cluster Reindex?
Date
Msg-id 87pt5blmgo.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Which Order Vacuum Full Analyze Cluster Reindex?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Which Order Vacuum Full Analyze Cluster Reindex?
List pgsql-general
Tree view 
Tom Lane <tgl@sss.pgh.pa.us> writes:

> If you are going to CLUSTER then you can forget the VACUUM part
> entirely.  Just do CLUSTER and then ANALYZE.

Out of curiosity, does cluster also effectively do a reindex?

--
greg

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: performance of IN (subquery)
Next
From: Richard Poole
Date:
Subject: Re: PSql won't Let me Set Varchar Column to 'true'