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

On Monday 13 October 2008 16:45:35 Joshua Drake wrote:
> On Mon, 13 Oct 2008 15:34:04 -0500
>
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> > ccdev=# select pg_total_relation_size('"DbTranImageStatus"');
> > pg_total_relation_size
> > ------------------------
> > 253952
> > (1 row)
> >
> > ccdev=# cluster "DbTranImageStatus";
> > CLUSTER
> > ccdev=# select pg_total_relation_size('"DbTranImageStatus"');
> > pg_total_relation_size
> > ------------------------
> > 32768
> > (1 row)
> >
> > -Kevin
>
> Although I think it is an interesting bit of information, I find that
> "if" I am going to be clustering, I have already done the above.
>
>

I agree with that, though I still wouldn't mind seeing some size specific
information, similar to what vacuum verbose emits.. eg.

INFO: "my_users_mods": removed 790 row versions in 4 pages
INFO: "my_users_mods": found 790 removable, 308 nonremovable row versions in
6 pages

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL