ora_btree_gin

ivorysql : Support for indexing oracle datatypes in GIN

Overview

ID	Extension	Package	Version	Category	License	Language
9150	ora_btree_gin	ivorysql	`1.0`	SIM	Apache-2.0	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-dt-	No	Yes	No	Yes	no	yes

Relationships
Schemas	`sys`
Requires	ivorysql_ora
Siblings	ivorysql_ora ora_btree_gist pg_get_functiondef plisql gb18030_2022

from contrib/ora_btree_gin/ora_btree_gin.control and package metadata

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	PIGSTY	`1.0`	18 17 16 15 14	`ivorysql`	`ivorysql_ora`
RPM	PIGSTY	`5.1`	18 17 16 15 14	`ivorysql5`	-
DEB	PIGSTY	`5.1`	18 17 16 15 14	`ivorysql-5`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	MISS	MISS	MISS	MISS	MISS
el8.aarch64	MISS	MISS	MISS	MISS	MISS
el9.x86_64	MISS	MISS	MISS	MISS	MISS
el9.aarch64	MISS	MISS	MISS	MISS	MISS
el10.x86_64	MISS	MISS	MISS	MISS	MISS
el10.aarch64	MISS	MISS	MISS	MISS	MISS
d12.x86_64	MISS	MISS	MISS	MISS	MISS
d12.aarch64	MISS	MISS	MISS	MISS	MISS
d13.x86_64	MISS	MISS	MISS	MISS	MISS
d13.aarch64	MISS	MISS	MISS	MISS	MISS
u22.x86_64	MISS	MISS	MISS	MISS	MISS
u22.aarch64	MISS	MISS	MISS	MISS	MISS
u24.x86_64	MISS	MISS	MISS	MISS	MISS
u24.aarch64	MISS	MISS	MISS	MISS	MISS

Source

Repository

github.com/IvorySQL/IvorySQL/tree/master/contrib/ora_btree_gin

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.

Last updated on 2026-03-12

ivorysql_ora ora_btree_gist