9.0 VACUUM FULL vs. ALTER TABLE?

Поиск
Список
Период
Сортировка
От Noah Misch
Тема 9.0 VACUUM FULL vs. ALTER TABLE?
Дата
Msg-id 20100306040226.GA4509@tornado.leadboat.com
обсуждение исходный текст
Ответы Re: 9.0 VACUUM FULL vs. ALTER TABLE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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, or will it essentially boil down to
two different spellings of the same request?

CREATE TABLE t (x int);
VACUUM FULL t;
-- versus
ALTER TABLE t ALTER x TYPE int;

Thanks,
nm

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Optimizations
Следующее
От: venkatrao.b@tcs.com
Дата:
Сообщение: How to find details of arguments in all functions in postgre - One solution