Re: Which Order Vacuum Full Analyze Cluster Reindex?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "borajetta" <borajetta(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Which Order Vacuum Full Analyze Cluster Reindex?
Date: 2004-08-28 03:14:16
Message-ID: 15050.1093662856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"borajetta" <borajetta(at)hotmail(dot)com> writes:
> I am trying to firgure out what the best order is?

> Vacuum Full table;
> Cluster table;
> Analyze table;

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

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-08-28 05:13:06 Re: pg_autovacuum start-script
Previous Message Matthew T. O'Connor 2004-08-28 02:33:14 Re: pg_autovacuum start-script