Measuring degredation of CLUSTER INDEX operation

Поиск
Список
Период
Сортировка
От Bryce Nesbitt
Тема Measuring degredation of CLUSTER INDEX operation
Дата
Msg-id 49189186.4070805@obviously.com
обсуждение исходный текст
Ответы Re: Measuring degredation of CLUSTER INDEX operation  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-sql
I've got a table for which "CLUSTER tablename USING index" makes an 
order of magnitude difference.

Are there ways to determine how "unclustered" this table becomes over 
time, so I can schedule downtime to recluster?  I could use the pg_stat 
tables, but this seems awkward.
               -Bryce

NB: For manual optimization work, it would be handy to have a feature in 
"ANALYZE VERBOSE" which gives a measure from 0-100%, right next to the 
"rows examined".  100% would be an optimally clustered result.  0% would 
be every row came from a distinct block on disc.

Related links:
http://www.postgresql.org/docs/8.3/static/sql-cluster.html
http://www.postgresonline.com/journal/index.php?/archives/10-How-does-CLUSTER-ON-improve-index-performance.html



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

Предыдущее
От: "Johnson, Michael L."
Дата:
Сообщение: Re: Subsorting GROUP BY data
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Measuring degredation of CLUSTER INDEX operation