Question about CLUSTER

Поиск
Список
Период
Сортировка
От salman
Тема Question about CLUSTER
Дата
Msg-id 47B0AA1F.8040101@quietcaresystems.com
обсуждение исходный текст
Ответы Re: [PERFORM] Question about CLUSTER
Список pgsql-admin
Hello,

I'm planning to cluster a few large tables in our database but I'm
unable to find any recommendations/documentation on best practices --
Mainly, whether it's better to use an index which has a higher idx_scan
value, a higher idx_tup_read value, or the higest idx_tup_fetch value.

I'm assuming that idx_tup_read would probably be the best choice, but
want to get other opinions before proceeding.

Can anyone point me to docs which explain this better?

-salman



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

Предыдущее
От: Chander Ganesan
Дата:
Сообщение: Re: 8.3.0 upgrade, confused by documentation
Следующее
От: "Tena Sakai"
Дата:
Сообщение: Re: 8.3.0 upgrade, confused by documentation