Re: 9.0 VACUUM FULL vs. ALTER TABLE?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.0 VACUUM FULL vs. ALTER TABLE?
Дата
Msg-id 29527.1267889250@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 9.0 VACUUM FULL vs. ALTER TABLE?  (Noah Misch <noah@leadboat.com>)
Список pgsql-general
Noah Misch <noah@leadboat.com> writes:
> I understand that 9.0 will have a new implementation of VACUUM FULL that follows
> a rewrite strategy like CLUSTER or ALTER TABLE.  What differences will remain
> between VACUUM FULL and a no-op ALTER TABLE that rewrites?  Will there remain
> situations in which to prefer the latter,

No.  They're pretty much the same.

            regards, tom lane

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

Предыдущее
От: Adrian von Bidder
Дата:
Сообщение: Filesysstems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: What's the best way to deal with the pk_seq sequence value after a restore (bulk loading)?