Re: TODO item: adding VERBOSE option to CLUSTER [with patch]

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.