Re: VACUUM vs VACUUM ANALYZE vs CLUSTER - Mailing list pgsql-novice

From Sheldon Hearn
Subject Re: VACUUM vs VACUUM ANALYZE vs CLUSTER
Date
Msg-id 3797.1000994793@axl.seasidesoftware.co.za
Whole thread Raw
In response to Re: VACUUM vs VACUUM ANALYZE vs CLUSTER  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM vs VACUUM ANALYZE vs CLUSTER
Next
From: Danny Aldham
Date:
Subject: UPDATE and DELETE fail in strange way