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.Grittner@wicourts.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