How frequently to defrag(cluster)

Поиск
Список
Период
Сортировка
От A J
Тема How frequently to defrag(cluster)
Дата
Msg-id 1311191898.49250.YahooMailNeo@web120015.mail.ne1.yahoo.com
обсуждение исходный текст
Ответы Re: How frequently to defrag(cluster)  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-admin
I understand that 'cluster' performs the role of defrag (along with rewriting in index order) in Postgres.
How frequently does one have to run cluster ? Any thumb-rules  or experience ? How do I find if my table is fragmented enough to need a cluster ?
We are still to use Postgres in production, just evaluating at this point.

Thanks for any pointers.

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

Предыдущее
От: Bob Lunney
Дата:
Сообщение: Re: Problem retrieving large records (bytea) data from a table
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: How frequently to defrag(cluster)