Re: Need help in reclaiming disk space by deleting the selected records

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Need help in reclaiming disk space by deleting the selected records
Дата
Msg-id 201209141435.08639.andres@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Need help in reclaiming disk space by deleting the selected records  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: Need help in reclaiming disk space by deleting the selected records  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
Hi,

On Friday, September 14, 2012 01:29:59 AM Steve Crawford wrote:
> 2. CLUSTER is typically way faster than VACUUM FULL and rebuilds the
> indexes as well but it temporarily requires sufficient disk-space to
> write out a copy of the table being clustered.
Thats not the case anymore since 9.0 btw. These days VACUUM FULL does the same
thing CLUSTER does just without sorting.

Greetings,

Andres
--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: application for postgres Log
Следующее
От: Robert Sosinski
Дата:
Сообщение: Seeing tables with the same name on different schemas