ora_btree_gin

Overview

from contrib/ora_btree_gin/ora_btree_gin.control and package metadata

Version

Build

You can build the RPM / DEB packages for ivorysql using pig build:

pig build pkg ivorysql         # build RPM / DEB packages

Install

You can install ivorysql directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

pig install ivorysql;          # Install for current active PG version

pig ext install -y ivorysql -v 18  # PG 18

dnf install -y ivorysql-18       # PG 18

apt install -y ivorysql-18   # PG 18

Create Extension:

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.