columnar

Hydra Columnar extension

Overview

PackageVersionCategoryLicenseLanguage
hydra1.1.2OLAPAGPL-3.0C
IDExtensionBinLibLoadCreateTrustRelocSchema
2410columnarNoYesNoYesNoNo-
Relatedcitus citus_columnar pg_mooncake timescaledb pg_analytics pg_parquet pg_duckdb duckdb_fdw

conflict with citus columnar, obsolete, no longer maintained

Version

TypeRepoVersionPG VerPackageDeps
EXTPIGSTY1.1.21817161514hydra-
RPMPIGSTY1.1.21817161514hydra_$v-
DEBPIGSTY1.1.21817161514postgresql-$v-hydra-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64PIGSTY MISSPIGSTY MISS
el8.aarch64PIGSTY MISSPIGSTY MISS
el9.x86_64PIGSTY MISSPIGSTY MISS
el9.aarch64PIGSTY MISSPIGSTY MISS
el10.x86_64PIGSTY MISSPIGSTY MISS
el10.aarch64PIGSTY MISSPIGSTY MISS
d12.x86_64PIGSTY MISSPIGSTY MISS
d12.aarch64PIGSTY MISSPIGSTY MISS
d13.x86_64PIGSTY MISSPIGSTY MISS
d13.aarch64PIGSTY MISSPIGSTY MISS
u22.x86_64PIGSTY MISSPIGSTY MISS
u22.aarch64PIGSTY MISSPIGSTY MISS
u24.x86_64PIGSTY MISSPIGSTY MISS
u24.aarch64PIGSTY MISSPIGSTY MISS

Build

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

pig build pkg hydra         # build RPM / DEB packages

Install

You can install hydra 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 hydra;          # Install for current active PG version
pig ext install -y hydra -v 16  # PG 16
pig ext install -y hydra -v 15  # PG 15
pig ext install -y hydra -v 14  # PG 14
dnf install -y hydra_16       # PG 16
dnf install -y hydra_15       # PG 15
dnf install -y hydra_14       # PG 14
apt install -y postgresql-16-hydra   # PG 16
apt install -y postgresql-15-hydra   # PG 15
apt install -y postgresql-14-hydra   # PG 14

Create Extension:

CREATE EXTENSION columnar;

Last Modified 2026-03-12: add pg extension catalog (95749bf)