The btree_gin module provides sample generalized inverted index (GIN) operator classes that implement B-tree equivalent behavior for certain data types.

The Greenplum Database btree_gin module is equivalent to the PostgreSQL btree_gin module. There are no Greenplum Database or MPP-specific considerations for the module.

Installing and Registering the Module

The btree_gin module is installed when you install Greenplum Database. Before you can use any of the functions defined in the module, you must register the btree_gin extension in each database in which you want to use the functions:

CREATE EXTENSION btree_gin;

Refer to Installing Additional Supplied Modules for more information.

Greenplum Database Limitations

The VMware Greenplum Query Optimizer (GPORCA) does not support queries that access an index with op_class, such queries will fall back to the Postgres Planner

Module Documentation

See btree_gin in the PostgreSQL documentation for detailed information about the individual functions in this module.

check-circle-line exclamation-circle-line close-line
Scroll to top icon