Extensions
storage_engine

storage_engine

storage_engine : colcompress and rowcompress Table Access Methods with vectorized execution

Overview

ID Extension Package Version Category License Language
2450
storage_engine
storage_engine
 1.0.7
OLAP
AGPL-3.0
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sLd--
No
Yes
Yes
Yes
no
no
Relationships
Schemas engine

release 1.0.7; SQL v1.0

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 1.0.7
18
17
16
15
14
 storage_engine -
RPM
PIGSTY
 1.0.7
18
17
16
15
14
 storage_engine_$v -
DEB
PIGSTY
 1.0.7
18
17
16
15
14
 postgresql-$v-storage-engine -
Linux / PG PG18 PG17 PG16 PG15 PG14
el8.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
el8.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
el9.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
el9.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
el10.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
el10.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
d12.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
d12.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
d13.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
d13.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
u22.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
u22.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
u24.x86_64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
u24.aarch64
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
PIGSTY 1.0.7
Package Version OS ORG SIZE File URL
storage_engine_18 1.0.7 el8.x86_64 pigsty 182.5 KiB storage_engine_18-1.0.7-1PIGSTY.el8.x86_64.rpm
storage_engine_18 1.0.7 el8.aarch64 pigsty 174.4 KiB storage_engine_18-1.0.7-1PIGSTY.el8.aarch64.rpm
storage_engine_18 1.0.7 el9.x86_64 pigsty 154.4 KiB storage_engine_18-1.0.7-1PIGSTY.el9.x86_64.rpm
storage_engine_18 1.0.7 el9.aarch64 pigsty 150.0 KiB storage_engine_18-1.0.7-1PIGSTY.el9.aarch64.rpm
storage_engine_18 1.0.7 el10.x86_64 pigsty 156.7 KiB storage_engine_18-1.0.7-1PIGSTY.el10.x86_64.rpm
storage_engine_18 1.0.7 el10.aarch64 pigsty 151.0 KiB storage_engine_18-1.0.7-1PIGSTY.el10.aarch64.rpm
postgresql-18-storage-engine 1.0.7 d12.x86_64 pigsty 415.0 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~bookworm_amd64.deb
postgresql-18-storage-engine 1.0.7 d12.aarch64 pigsty 403.5 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~bookworm_arm64.deb
postgresql-18-storage-engine 1.0.7 d13.x86_64 pigsty 416.3 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~trixie_amd64.deb
postgresql-18-storage-engine 1.0.7 d13.aarch64 pigsty 405.7 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~trixie_arm64.deb
postgresql-18-storage-engine 1.0.7 u22.x86_64 pigsty 440.4 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~jammy_amd64.deb
postgresql-18-storage-engine 1.0.7 u22.aarch64 pigsty 434.0 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~jammy_arm64.deb
postgresql-18-storage-engine 1.0.7 u24.x86_64 pigsty 423.2 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~noble_amd64.deb
postgresql-18-storage-engine 1.0.7 u24.aarch64 pigsty 419.0 KiB postgresql-18-storage-engine_1.0.7-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
storage_engine_17 1.0.7 el8.x86_64 pigsty 182.0 KiB storage_engine_17-1.0.7-1PIGSTY.el8.x86_64.rpm
storage_engine_17 1.0.7 el8.aarch64 pigsty 173.9 KiB storage_engine_17-1.0.7-1PIGSTY.el8.aarch64.rpm
storage_engine_17 1.0.7 el9.x86_64 pigsty 153.7 KiB storage_engine_17-1.0.7-1PIGSTY.el9.x86_64.rpm
storage_engine_17 1.0.7 el9.aarch64 pigsty 149.5 KiB storage_engine_17-1.0.7-1PIGSTY.el9.aarch64.rpm
storage_engine_17 1.0.7 el10.x86_64 pigsty 156.1 KiB storage_engine_17-1.0.7-1PIGSTY.el10.x86_64.rpm
storage_engine_17 1.0.7 el10.aarch64 pigsty 150.4 KiB storage_engine_17-1.0.7-1PIGSTY.el10.aarch64.rpm
postgresql-17-storage-engine 1.0.7 d12.x86_64 pigsty 413.6 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~bookworm_amd64.deb
postgresql-17-storage-engine 1.0.7 d12.aarch64 pigsty 402.4 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~bookworm_arm64.deb
postgresql-17-storage-engine 1.0.7 d13.x86_64 pigsty 414.9 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~trixie_amd64.deb
postgresql-17-storage-engine 1.0.7 d13.aarch64 pigsty 404.5 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~trixie_arm64.deb
postgresql-17-storage-engine 1.0.7 u22.x86_64 pigsty 503.8 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~jammy_amd64.deb
postgresql-17-storage-engine 1.0.7 u22.aarch64 pigsty 496.1 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~jammy_arm64.deb
postgresql-17-storage-engine 1.0.7 u24.x86_64 pigsty 420.9 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~noble_amd64.deb
postgresql-17-storage-engine 1.0.7 u24.aarch64 pigsty 418.0 KiB postgresql-17-storage-engine_1.0.7-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
storage_engine_16 1.0.7 el8.x86_64 pigsty 181.9 KiB storage_engine_16-1.0.7-1PIGSTY.el8.x86_64.rpm
storage_engine_16 1.0.7 el8.aarch64 pigsty 173.8 KiB storage_engine_16-1.0.7-1PIGSTY.el8.aarch64.rpm
storage_engine_16 1.0.7 el9.x86_64 pigsty 153.9 KiB storage_engine_16-1.0.7-1PIGSTY.el9.x86_64.rpm
storage_engine_16 1.0.7 el9.aarch64 pigsty 149.4 KiB storage_engine_16-1.0.7-1PIGSTY.el9.aarch64.rpm
storage_engine_16 1.0.7 el10.x86_64 pigsty 155.7 KiB storage_engine_16-1.0.7-1PIGSTY.el10.x86_64.rpm
storage_engine_16 1.0.7 el10.aarch64 pigsty 150.3 KiB storage_engine_16-1.0.7-1PIGSTY.el10.aarch64.rpm
postgresql-16-storage-engine 1.0.7 d12.x86_64 pigsty 412.9 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~bookworm_amd64.deb
postgresql-16-storage-engine 1.0.7 d12.aarch64 pigsty 402.1 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~bookworm_arm64.deb
postgresql-16-storage-engine 1.0.7 d13.x86_64 pigsty 414.4 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~trixie_amd64.deb
postgresql-16-storage-engine 1.0.7 d13.aarch64 pigsty 403.9 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~trixie_arm64.deb
postgresql-16-storage-engine 1.0.7 u22.x86_64 pigsty 499.2 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~jammy_amd64.deb
postgresql-16-storage-engine 1.0.7 u22.aarch64 pigsty 491.9 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~jammy_arm64.deb
postgresql-16-storage-engine 1.0.7 u24.x86_64 pigsty 420.0 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~noble_amd64.deb
postgresql-16-storage-engine 1.0.7 u24.aarch64 pigsty 417.6 KiB postgresql-16-storage-engine_1.0.7-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
storage_engine_15 1.0.7 el8.x86_64 pigsty 185.4 KiB storage_engine_15-1.0.7-1PIGSTY.el8.x86_64.rpm
storage_engine_15 1.0.7 el8.aarch64 pigsty 177.2 KiB storage_engine_15-1.0.7-1PIGSTY.el8.aarch64.rpm
storage_engine_15 1.0.7 el9.x86_64 pigsty 173.4 KiB storage_engine_15-1.0.7-1PIGSTY.el9.x86_64.rpm
storage_engine_15 1.0.7 el9.aarch64 pigsty 167.6 KiB storage_engine_15-1.0.7-1PIGSTY.el9.aarch64.rpm
storage_engine_15 1.0.7 el10.x86_64 pigsty 175.2 KiB storage_engine_15-1.0.7-1PIGSTY.el10.x86_64.rpm
storage_engine_15 1.0.7 el10.aarch64 pigsty 168.4 KiB storage_engine_15-1.0.7-1PIGSTY.el10.aarch64.rpm
postgresql-15-storage-engine 1.0.7 d12.x86_64 pigsty 419.0 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~bookworm_amd64.deb
postgresql-15-storage-engine 1.0.7 d12.aarch64 pigsty 406.2 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~bookworm_arm64.deb
postgresql-15-storage-engine 1.0.7 d13.x86_64 pigsty 420.6 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~trixie_amd64.deb
postgresql-15-storage-engine 1.0.7 d13.aarch64 pigsty 408.3 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~trixie_arm64.deb
postgresql-15-storage-engine 1.0.7 u22.x86_64 pigsty 519.9 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~jammy_amd64.deb
postgresql-15-storage-engine 1.0.7 u22.aarch64 pigsty 512.9 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~jammy_arm64.deb
postgresql-15-storage-engine 1.0.7 u24.x86_64 pigsty 440.0 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~noble_amd64.deb
postgresql-15-storage-engine 1.0.7 u24.aarch64 pigsty 434.1 KiB postgresql-15-storage-engine_1.0.7-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
storage_engine_14 1.0.7 el8.x86_64 pigsty 185.8 KiB storage_engine_14-1.0.7-1PIGSTY.el8.x86_64.rpm
storage_engine_14 1.0.7 el8.aarch64 pigsty 177.5 KiB storage_engine_14-1.0.7-1PIGSTY.el8.aarch64.rpm
storage_engine_14 1.0.7 el9.x86_64 pigsty 173.8 KiB storage_engine_14-1.0.7-1PIGSTY.el9.x86_64.rpm
storage_engine_14 1.0.7 el9.aarch64 pigsty 167.5 KiB storage_engine_14-1.0.7-1PIGSTY.el9.aarch64.rpm
storage_engine_14 1.0.7 el10.x86_64 pigsty 175.5 KiB storage_engine_14-1.0.7-1PIGSTY.el10.x86_64.rpm
storage_engine_14 1.0.7 el10.aarch64 pigsty 168.9 KiB storage_engine_14-1.0.7-1PIGSTY.el10.aarch64.rpm
postgresql-14-storage-engine 1.0.7 d12.x86_64 pigsty 420.5 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~bookworm_amd64.deb
postgresql-14-storage-engine 1.0.7 d12.aarch64 pigsty 407.1 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~bookworm_arm64.deb
postgresql-14-storage-engine 1.0.7 d13.x86_64 pigsty 421.8 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~trixie_amd64.deb
postgresql-14-storage-engine 1.0.7 d13.aarch64 pigsty 409.9 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~trixie_arm64.deb
postgresql-14-storage-engine 1.0.7 u22.x86_64 pigsty 521.9 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~jammy_amd64.deb
postgresql-14-storage-engine 1.0.7 u22.aarch64 pigsty 514.2 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~jammy_arm64.deb
postgresql-14-storage-engine 1.0.7 u24.x86_64 pigsty 440.9 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~noble_amd64.deb
postgresql-14-storage-engine 1.0.7 u24.aarch64 pigsty 435.7 KiB postgresql-14-storage-engine_1.0.7-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/saulojb/storage_engine
 Source Tarball
storage_engine-1.0.7.tar.gz
 
pig build pkg storage_engine;		# build rpm/deb

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 storage_engine;		# install via package name, for the active PG version

pig install storage_engine -v 18;   # install for PG 18
pig install storage_engine -v 17;   # install for PG 17
pig install storage_engine -v 16;   # install for PG 16
pig install storage_engine -v 15;   # install for PG 15
pig install storage_engine -v 14;   # install for PG 14

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'storage_engine';

Create this extension with:

CREATE EXTENSION storage_engine;
Last updated on
pg_mooncakepg_clickhouse