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 2026-04-19

pg_mooncake pg_clickhouse