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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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