Re: [RFC] CLUSTER VERBOSE

Grzegorz Jaskiewicz wrote:
> Because CLUSTER is divided into two major operations, (data reordering, 
> index rebuild) - I see it this way:
> 
> CLUSTER on I: <index name> T: <table name>, data reordering
> CLUSTER on I: <index name> T: <table name>, index rebuild

Something like that would be nice to see how long each step takes, like 
vacuum verbose.

> and than:
> CLUSTER 10%
> CLUSTER 12% , etc

We don't have progress indicators for any other commands, and I don't 
see why we should add one for cluster in particular. Sure, progress 
indicators are nice, but we should rather try to add some kind of a 
general progress indicator support that would support SELECTs for 
example. I know it's much harder, but also much more useful.

> I am looking for opinions, on what information should be presented.

What would be useful is some kind of a metric of how (de)clustered the 
table was before CLUSTER, and the same # of dead vs. live row counts 
that vacuum verbose prints.

We don't really have a good metric for clusteredness, as have been 
discussed before, so if you can come up with a good one that would be 
useful in the planner as well, that would be great.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com