btree_gin

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

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

Installing and Registering the Module

The btree_gin module is installed when you install SynxDB. 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.

SynxDB Limitations

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