reindexdb
Rebuilds indexes in a database.
Synopsis
reindexdb [connection-option ...] [--table | -t table ] [--index | -i index ] [dbname] reindexdb [connection-option ...] [--all | -a] reindexdb [connection-option ...] [--system | -s] [dbname] reindexdb --help reindexdb --version
Description
reindexdb is a utility for rebuilding indexes in Greenplum Database, and is a wrapper around the SQL command REINDEX.
Options
- -a | --all
- Reindex all databases.
- [-d] dbname | [--dbname] dbname
- Specifies the name of the database to be reindexed. If this is not specified and -all is not used, the database name is read from the environment variable PGDATABASE. If that is not set, the user name specified for the connection is used.
- -e | --echo
- Echo the commands that reindexdb generates and sends to the server.
- -i index | --index index
- Recreate index only.
- -q | --quiet
- Do not display a response.
- -s | --system
- Reindex system catalogs.
- -t table | --table table
- Reindex table only.
Connection Options
- -h host | --host host
- Specifies the host name of the machine on which the Greenplum master database server is running. If not specified, reads from the environment variable PGHOST or defaults to localhost.
- -p port | --port port
- Specifies the TCP port on which the Greenplum master database server is listening for connections. If not specified, reads from the environment variable PGPORT or defaults to 5432.
- -U username | --username username
- The database role name to connect as. If not specified, reads from the environment variable PGUSER or defaults to the current system user name.
- -w | --no-password
- Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a .pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password.
- -W | --password
- Force a password prompt.
Notes
reindexdb might need to connect several times to the master server, asking for a password each time. It is convenient to have a ~/.pgpass file in such cases.
Examples
To reindex the database mydb:
reindexdb mydb
To reindex the table foo and the index bar in a database named abcd:
reindexdb --table foo --index bar abcd