Re: TODO item: adding VERBOSE option to CLUSTER [with patch] - Mailing list pgsql-hackers

Kevin Grittner wrote:
>>>> "Jim Cox" <shakahshakah@gmail.com> wrote: 
>> if present an INFO message is generated which displays
>> the schema.tblname just before actual clustering is kicked off (see
> example
>> below).
>  
>> postgres=# CLUSTER VERBOSE ;
>> INFO:  clustering "public.my_b"
>> INFO:  clustering "public.my_c"
>> INFO:  clustering "public.my_a"
>> CLUSTER
>  
> Would it make sense to display the pg_total_relation_size before and
> after?

Assuming you run CLUSTER as a replacement for VACUUM FULL, yes. More 
interesting would be a metric of "clusteredness", I think.

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