[RFC] CLUSTER VERBOSE

From: Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: [RFC] CLUSTER VERBOSE
Date: 2007-03-15 12:40:30
Message-ID: 9984E5FD-0945-406B-96F9-26E026E7758A@pointblue.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi folks,

I figure - I should start brand new thread for this one - so here you
go.

I am in a need for verbose CLUSTER. Ie. one that would give me
feedback and progress.
Because CLUSTER is divided into two major operations, (data
reordering, index rebuild) - I see it this way:

CLUSTER on I: <index name> T: <table name>, data reordering
CLUSTER on I: <index name> T: <table name>, index rebuild

and than:
CLUSTER 10%
CLUSTER 12% , etc

(yeah, I know how hard it is to write good progress ..).

I don't have even slight doubt that it can be useful, just like
"VACUUM VERBOSE" is. So no question about it.
I am seeking for comments. Ideas.
The patch would not be very intrusive, atm no one is using VERBOSE
for CLUSTER, because it is not there. And nothing would change in
this area.
I am looking for opinions, on what information should be presented.
Perhaps there's also use for some information it might gather
elsewhere (stats, etc) - but that's not really my point atm.

Thanks for all comments.
btw, I would really appreciate not CCing me on this, I am subscribed
here for yeaaars now (8.0 times).

ta.

--
Grzegorz Jaskiewicz

C/C++ freelance for hire

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-03-15 13:06:39 Re: how to add seconds to a TimestampTz
Previous Message Grzegorz Jaskiewicz 2007-03-15 12:11:37 Re: where to add/change commands