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
000_reindex_verbose_v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers