Re: loading data, creating indexes, clustering, vacuum...

Поиск
Список
Период
Сортировка
От Angva
Тема Re: loading data, creating indexes, clustering, vacuum...
Дата
Msg-id 1165599211.622120.148270@l12g2000cwl.googlegroups.com
обсуждение исходный текст
Ответ на loading data, creating indexes, clustering, vacuum...  ("Angva" <angvaw@gmail.com>)
Ответы Re: loading data, creating indexes, clustering, vacuum...
Re: loading data, creating indexes, clustering, vacuum...
Список pgsql-general
> clustering also removes the dead tuples.

I have a followup question. What if the set of dead tuples is too big
and I need to VACUUM FULL, as opposed to VACUUM. (The update size
varies greatly from day to day.) Will the clustering effectively do a
VACUUM FULL, or just a VACUUM?

Thanks again for your help,
Mark


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