Skip site navigation (1) Skip section navigation (2)

Measuring degredation of CLUSTER INDEX operation

From: Bryce Nesbitt <bryce2(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Measuring degredation of CLUSTER INDEX operation
Date: 2008-11-10 19:54:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.


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:


pgsql-sql by date

Next:From: Scott MarloweDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group