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

Re: VACUUM vs VACUUM ANALYZE vs CLUSTER

From: Sheldon Hearn <sheldonh(at)starjuice(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: VACUUM vs VACUUM ANALYZE vs CLUSTER
Date: 2001-09-20 14:06:33
Message-ID: 3797.1000994793@axl.seasidesoftware.co.za (view raw or flat)
Thread:
Lists: pgsql-novice

On Thu, 20 Sep 2001 09:58:02 -0400, Tom Lane wrote:

> Er, what?  Depending on your situation, I think a separate ANALYZE might
> be useful in production.

Oh for _sure_!  I was just clarifying your position on the use of 7.2 in
a production environment.

> It's on the TODO list.  Dunno when someone will get around to it.

Once I got past the horror of losing my primary key and finding that
ALTER TABLE doesn't support ADD CONSTRAINT ... PRIMARY KEY, things got
better. :-)

Ciao,
Sheldon.

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-09-20 14:13:11
Subject: Re: VACUUM vs VACUUM ANALYZE vs CLUSTER
Previous:From: Tom LaneDate: 2001-09-20 14:00:45
Subject: Re: Replace Old Table with New

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