From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
---|---|
To: | Jim Cox <shakahshakah(at)gmail(dot)com> |
Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: TODO item: adding VERBOSE option to CLUSTER [with patch] |
Date: | 2008-10-13 11:22:10 |
Message-ID: | 48F32F62.5040205@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jim Cox wrote:
> On Fri, Oct 10, 2008 at 10:23 AM, Heikki Linnakangas <
> heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>
>> Kevin Grittner wrote:
>>
>>> "Jim Cox" <shakahshakah(at)gmail(dot)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
No, I was thinking of something along the lines of:
INFO: clustering "public.my_c"
INFO: complete, was 33%, now 100% clustered
The only such measure that we have is the correlation, which isn't very
good anyway, so I'm not sure if that's worthwhile.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2008-10-13 11:44:23 | out-of-date comment in auto-generated oidjoins.sql |
Previous Message | Laurent Wandrebeck | 2008-10-13 09:44:36 | Column level triggers |