VACUUM FULL vs CLUSTER

Поиск
Список
Период
Сортировка
От Markus Benne
Тема VACUUM FULL vs CLUSTER
Дата
Msg-id 1127242399.26562.15.camel@host-140.engineering.n-able.com
обсуждение исходный текст
Ответ на unsubscribe  (Nelba Sánchez Rojas <nnsanche@puc.cl>)
Ответы Re: VACUUM FULL vs CLUSTER  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
I have a table that is purged by 25% each night.  I'd like to do a
vacuum nightly after the purge to reclaim the space, but I think I'll
still need to do a vacuum full weekly.

Would there be any benefit to doing a cluster instead of the vacuum?


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: FW: Deadlock Issue with PostgreSQL
Следующее
От: "Ahmad Fajar"
Дата:
Сообщение: tsearch2 seem very slow