Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group