Proposal : REINDEX xxx VERBOSE - Mailing list pgsql-hackers

From Sawada Masahiko
Subject Proposal : REINDEX xxx VERBOSE
Date
Msg-id CAD21AoA0pK3YcOZAFzMae+2fcc3oGp5zoRggDyMNg5zoaWDhdQ@mail.gmail.com
Whole thread Raw
Responses Re: Proposal : REINDEX xxx VERBOSE  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Hi all,

Attached patch adds VERBOSE option to REINDEX commands.
The another maintaining commands(VACUUM FULL, CLUSTER) has VERBOSE option,
but REINDEX has not been had it.

Examples is following,

- REINDEX TABLE
[postgres][5432](1)=# REINDEX TABLE VERBOSE hoge;
INFO:  index "hoge_idx" was reindexed.
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.02 sec.
INFO:  index "hoge2_idx" was reindexed.
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
REINDEX

- REINDEX SCHEMA
[postgres][5432](1)=# REINDEX SCHEMA VERBOSE s;
INFO:  index "hoge_idx" was reindexed.
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "hoge2_idx" was reindexed.
DETAIL:  CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  indexes of whole table "s.hoge" were reindexed
REINDEX

Please give me feedbacks.

Regards,

-------
Sawada Masahiko

Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Implementation of global temporary tables?
Next
From: Andres Freund
Date:
Subject: Re: Implementation of global temporary tables?