Kevin Grittner wrote:
"Jim Cox" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers