postgres=# select version();
version
------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.22 on x86_64-unknown-linux-gnu, compiled by GCC gcc (SUSE Linux) 4.3.4 [gcc-4_3-branch revision 152973]
(1 row)
REINDEX
postgres=# reindex table test; -->重建和表test有关的索引
REINDEX
postgres@linux-o8rc:~> reindexdb postgres -->重建postgres数据库下所有的索引
NOTICE: table "pg_class" was reindexed
NOTICE: table "pg_class" was reindexed
NOTICE: table "sql_features" was reindexed
NOTICE: table "sql_features" was reindexed
NOTICE: table "sql_implementation_info" was reindexed
NOTICE: table "sql_im
version
------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.22 on x86_64-unknown-linux-gnu, compiled by GCC gcc (SUSE Linux) 4.3.4 [gcc-4_3-branch revision 152973]
(1 row)
注意:reindex 会造成全表锁。
REINDEX
postgres=# reindex table test; -->重建和表test有关的索引
REINDEX
postgres@linux-o8rc:~> reindexdb postgres -->重建postgres数据库下所有的索引
NOTICE: table "pg_class" was reindexed
NOTICE: table "pg_class" was reindexed
NOTICE: table "sql_features" was reindexed
NOTICE: table "sql_features" was reindexed
NOTICE: table "sql_implementation_info" was reindexed
NOTICE: table "sql_im