documentdb_extended_rum

Overview

Version

Build

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

pig build pkg documentdb         # build RPM / DEB packages

Install

You can install documentdb 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:

• Install
• pig
• dnf
• apt

pig install documentdb;          # Install for current active PG version

pig ext install -y documentdb -v 18  # PG 18
pig ext install -y documentdb -v 17  # PG 17
pig ext install -y documentdb -v 16  # PG 16
pig ext install -y documentdb -v 15  # PG 15

dnf install -y documentdb_18       # PG 18
dnf install -y documentdb_17       # PG 17
dnf install -y documentdb_16       # PG 16
dnf install -y documentdb_15       # PG 15

apt install -y postgresql-18-documentdb   # PG 18
apt install -y postgresql-17-documentdb   # PG 17
apt install -y postgresql-16-documentdb   # PG 16
apt install -y postgresql-15-documentdb   # PG 15

Preload:

shared_preload_libraries = 'pg_documentdb_extended_rum';

Create Extension:

CREATE EXTENSION documentdb_extended_rum;

Usage

documentdb_extended_rum: DocumentDB Extended RUM index access method

The documentdb_extended_rum extension provides an enhanced RUM (Recursive Union Merge) index access method for DocumentDB on PostgreSQL. It improves query performance for document-based workloads.

Overview

This extension extends the RUM index type to better support BSON document indexing within DocumentDB. It provides optimized index access methods for:

• Full-text search on document fields
• Compound index operations on BSON data
• Efficient range queries and sorting on indexed document properties

Prerequisites

Requires documentdb_core to be installed.

Enabling

CREATE EXTENSION documentdb_extended_rum;

The extended RUM indexes are automatically utilized by the DocumentDB query planner when appropriate for document query patterns.