Re: VACUUM vs VACUUM ANALYZE vs CLUSTER

Поиск
Список
Период
Сортировка
От Sheldon Hearn
Тема Re: VACUUM vs VACUUM ANALYZE vs CLUSTER
Дата
Msg-id 3797.1000994793@axl.seasidesoftware.co.za
обсуждение исходный текст
Ответ на Re: VACUUM vs VACUUM ANALYZE vs CLUSTER  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM vs VACUUM ANALYZE vs CLUSTER
Следующее
От: Danny Aldham
Дата:
Сообщение: UPDATE and DELETE fail in strange way