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.
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.
The Tanzu Greenplum Query Optimizer (GPORCA) does not support queries that access an index with
op_class, such queries will fall back to the Postgres Planner
See btree_gin in the PostgreSQL documentation for detailed information about the individual functions in this module.