How well clustered is a table?

From: Jonathan Blitz <jblitz(at)013(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: How well clustered is a table?
Date: 2009-11-22 13:03:25
Message-ID: F5586392E22248A4BDB08EB05EAAC4DC@jblaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was wondering if there is some indication of how well clustered a table
is.

In other words, when a Cluster command is performed then a table would be
100% clustered.
As updates etc are made the table clowly loses its clustering.
Is there any indication as to how "bad" it is at any one point?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2009-11-22 13:44:08 Re: How well clustered is a table?
Previous Message Alban Hertroys 2009-11-22 12:45:44 Re: How to get RTREE performance from GIST index?