| From: | Joshua Drake <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Jim Cox" <shakahshakah(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: TODO item: adding VERBOSE option to CLUSTER [with patch] |
| Date: | 2008-10-13 20:45:35 |
| Message-ID: | 20081013134535.396e3f8a@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Renner | 2008-10-13 20:49:40 | Re: How is random_page_cost=4 ok? |
| Previous Message | Kris Jurka | 2008-10-13 20:41:40 | Re: There's some sort of race condition with the new FSM stuff |