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.
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.
pgsql-sql by date
|Next:||From: Scott Marlowe||Date: 2008-11-10 23:37:29|
|Subject: Re: Measuring degredation of CLUSTER INDEX operation|
|Previous:||From: Johnson, Michael L.||Date: 2008-11-10 18:06:42|
|Subject: Re: Subsorting GROUP BY data|