Skip site navigation (1) Skip section navigation (2)

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

From: "Jim Cox" <shakahshakah(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Date: 2008-10-10 12:53:25
Message-ID: c2ee6dbd0810100553gd328275ue2eb6e14bee70a8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Oct 9, 2008 at 9:37 AM, Jim Cox <shakahshakah(at)gmail(dot)com> wrote:

> Is anyone working the "CLUSTER: Add VERBOSE option..." TODO item listed
> on the PostgreSQL Wiki? If not, would it be wise for me to use
> VERBOSE handling in an existing command (e.g. VACUUM)
> as a guide while adding VERBOSE to CLUSTER?
>
>
A patch s/b attached which adds a "VERBOSE" option to the CLUSTER command as
mentioned in the following TODO item for CLUSTER: "Add VERBOSE option
to report tables as they are processed, like VACUUM VERBOSE".

In short, all three variations of the CLUSTER command now take an optional
"VERBOSE" arg, if present an INFO message is generated which displays
the schema.tblname just before actual clustering is kicked off (see example
below).

postgres=# CLUSTER ;
CLUSTER

postgres=# CLUSTER VERBOSE ;
INFO:  clustering "public.my_b"
INFO:  clustering "public.my_c"
INFO:  clustering "public.my_a"
CLUSTER

postgres=# CLUSTER public.my_c ;
CLUSTER

postgres=# CLUSTER public.my_c VERBOSE ;
INFO:  clustering "public.my_c"
CLUSTER

Attachment: cluster-verbose.patch
Description: text/x-diff (6.6 KB)

Responses

pgsql-hackers by date

Next:From: Andrew SullivanDate: 2008-10-10 13:00:21
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches
Previous:From: Michael RennerDate: 2008-10-10 12:44:20
Subject: Re: How is random_page_cost=4 ok?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group