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: (view raw, whole thread or download thread mbox)
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

postgres=# CLUSTER ;

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

postgres=# CLUSTER public.my_c ;

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

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


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-2017 The PostgreSQL Global Development Group