ora_btree_gin

ivorysql : Support for indexing oracle datatypes in GIN

Overview

Packages

Source

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install ivorysql;		# install via package name, for the active PG version
pig install ora_btree_gin;		# install by extension name, for the current active PG version

pig install ora_btree_gin -v 18;   # install for PG 18

Create this extension with:

CREATE EXTENSION ora_btree_gin CASCADE; -- requires ivorysql_ora

Usage

ora_btree_gin: Support for indexing oracle datatypes in GIN

The ora_btree_gin extension adds GIN (Generalized Inverted Index) operator class support for Oracle-compatible data types provided by IvorySQL.

Enabling

CREATE EXTENSION ora_btree_gin;

Creating GIN Indexes on Oracle Types

This extension allows you to create GIN indexes on Oracle-compatible data types such as NUMBER, VARCHAR2, and Oracle-style DATE, similar to how the standard btree_gin extension works for native PostgreSQL types.

CREATE TABLE t (val NUMBER);
CREATE INDEX t_val_gin_idx ON t USING gin (val);

Use Cases

GIN indexes with Oracle-compatible types are particularly useful for:

• Multi-column index queries where some columns use Oracle data types
• Queries combining full-text search with Oracle-type column filters
• Any scenario requiring inverted index support for Oracle-compatible data types

This extension is part of the IvorySQL Oracle compatibility suite and requires ivorysql_ora to be available.