Re: Does VACUUM reorder tables on clustered indices

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Does VACUUM reorder tables on clustered indices
Дата
Msg-id 13769.1134961702@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Does VACUUM reorder tables on clustered indices  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Does VACUUM reorder tables on clustered indices  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Does VACUUM reorder tables on clustered indices  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-sql
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Note that while reordering, CLUSTER also gets rid of dead tuples, so if
> you cluster you don't need to vacuum.

Just for the record, that behavior is seriously broken: it violates
MVCC if any of the deleted tuples are still visible to anyone else.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Need SQL Help Finding Current Status of members
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Does VACUUM reorder tables on clustered indices