gpbitmapreindex

Rebuilds bitmap indexes after a 3.3.x to 4.0.x upgrade.

[gpadmin@sachi ~]$ gpbitmapreindex --help

COMMAND NAME: gpbitmapreindex

*****************************************************

SYNOPSIS

*****************************************************

gpbitmapreindex -m { r | d | {l [-o <output_sql_file>]} }

[-h <master_host>] [-p <master_port>]

[-n <number_of_processes>] [-v]

gpmigrator --version

gpmigrator --help | -?

*****************************************************

DESCRIPTION

*****************************************************

The on-disk format of bitmap indexes has changed from release 3.3.x to 4.0.x. Users who upgrade must rebuild all bitmap indexes after upgrading to 4.0. The gpbitmapreindex utility facilitates the upgrade of bitmap indexes by either running the REINDEX command to reindex them, or running the DROP INDEX command to simply remove them.

If you decide to drop your bitmap indexes rather than reindex, run gpbitmapreindex in list --outfile mode first to output a SQL file that you can use to recreate the indexes later. You must be the Greenplum Database superuser (gpadmin) in order to run gpbitmapreindex.

*****************************************************

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.

-m {r|d|l} | --mode {reindex|drop|list}

Required. The bitmap index upgrade mode: either reindex, drop, or list all bitmap indexes in the system.

-n <number_of_processes> | --parallel <number_of_processes>

The number of bitmap indexes to reindex or drop in parallel. Valid values are 1-16. The default is 1.

-o <output_sql_file> | --outfile <output_sql_file>

When used with list mode, outputs a SQL file that can be used to recreate the bitmap indexes.

-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.

-v | --verbose

Show verbose output.

--version

Displays the version of this utility.

-? | --help

Displays the online help.

*****************************************************

EXAMPLES

*****************************************************

Reindex all bitmap indexes:

gpbitmapreindex -m r

Output a file of SQL commands that can be used to recreate all bitmap indexes:

gpbitmapreindex -m list --outfile /home/gpadmin/bmp_ix.sql

Drop all bitmap indexes and run in verbose mode:

gpbitmapreindex -m d -v

*****************************************************