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

Поиск
Список
Период
Сортировка
От Jim Cox
Тема Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Дата
Msg-id c2ee6dbd0810101013u644bd6bl7c48442b44d6ec7d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: TODO item: adding VERBOSE option to CLUSTER [with patch]  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Fri, Oct 10, 2008 at 10:23 AM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
Kevin Grittner wrote:
"Jim Cox" <shakahshakah@gmail.com> 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.

Something more like the following?

postgres=# CLUSTER VERBOSE ;
INFO:  clustering "public.my_b"
INFO:  complete, 0 rows scanned, 0 rows now live
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  clustering "public.my_c"
INFO:  complete, 20 rows scanned, 10 rows now live
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  clustering "public.my_a"
INFO:  complete, 10 rows scanned, 10 rows now live
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
CLUSTER

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LWLockAcquire with priority
Следующее
От: Michael Renner
Дата:
Сообщение: Re: How is random_page_cost=4 ok?