How to reorganize PostGresQL indexes on JMO r11.2?

Document ID : KB000053302
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

On NSM 3.x versions a utility called 'cashrcvr' can be used to reorganize the CADB indexes in tablespace CAICA7DB.
Which utility can we use to reorganize the JMO r11.2 PostGresQL tables?

Solution:

You can find under $PGSQL_HOME/bin a binary called 'reindexdb'.

If you execute 'reindexdb --help' you get following response which details the usage of the utility as an explanation of possible options

 # reindexdb --help
reindexdb reindexes a PostgreSQL database.
 
Usage:
  reindexdb [OPTION]... [DBNAME]
 
Options:
  -a, --all                 reindex all databases
  -s, --system              reindex system catalogs
  -d, --dbname=DBNAME       database to reindex
  -t, --table=TABLE         reindex specific table only
  -i, --index=INDEX         recreate specific index only
  -e, --echo                show the commands being sent to the server
  -q, --quiet               don't write any messages
  --help                    show this help, then exit
  --version                 output version information, then exit
 
Connection options:
  -h, --host=HOSTNAME       database server host or socket directory
  -p, --port=PORT           database server port
  -U, --username=USERNAME   user name to connect as
  -W, --password            prompt for password

Read the description of the SQL command REINDEX for details.

Report bugs to <pgsql-bugs@postgresql.org>.