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

Поиск
Список
Период
Сортировка
От Joshua Drake
Тема Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Дата
Msg-id 20081013134535.396e3f8a@jd-laptop
обсуждение исходный текст
Ответ на Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-hackers
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.


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/




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: There's some sort of race condition with the new FSM stuff
Следующее
От: Michael Renner
Дата:
Сообщение: Re: How is random_page_cost=4 ok?