Extensions
collection

collection

pgcollection : Memory optimized data type to be used inside of plpglsql func

Overview

ID Extension Package Version Category License Language
3630
collection
pgcollection
 1.1.0
TYPE
Apache-2.0
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
prefix
semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 1.1.0
18
17
16
15
14
13
 pgcollection -
RPM
PIGSTY
 1.1.0
18
17
16
15
14
13
 pgcollection_$v* -
DEB
PIGSTY
 1.1.0
18
17
16
15
14
13
 postgresql-$v-collection -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
el8.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
el9.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
el9.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
el10.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
el10.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
d12.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
d12.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
d13.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
d13.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
u22.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
u22.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
u24.x86_64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
u24.aarch64
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
PIGSTY 1.1.0
MISS
Package Version OS ORG SIZE File URL
pgcollection_18 1.1.0 el8.x86_64 pigsty 41.4 KiB pgcollection_18-1.1.0-1PIGSTY.el8.x86_64.rpm
pgcollection_18 1.1.0 el8.aarch64 pigsty 40.5 KiB pgcollection_18-1.1.0-1PIGSTY.el8.aarch64.rpm
pgcollection_18 1.1.0 el9.x86_64 pigsty 41.0 KiB pgcollection_18-1.1.0-1PIGSTY.el9.x86_64.rpm
pgcollection_18 1.1.0 el9.aarch64 pigsty 40.5 KiB pgcollection_18-1.1.0-1PIGSTY.el9.aarch64.rpm
pgcollection_18 1.1.0 el10.x86_64 pigsty 41.4 KiB pgcollection_18-1.1.0-1PIGSTY.el10.x86_64.rpm
pgcollection_18 1.1.0 el10.aarch64 pigsty 39.4 KiB pgcollection_18-1.1.0-1PIGSTY.el10.aarch64.rpm
postgresql-18-collection 1.1.0 d12.x86_64 pigsty 80.5 KiB postgresql-18-collection_1.1.0-1PIGSTY~bookworm_amd64.deb
postgresql-18-collection 1.1.0 d12.aarch64 pigsty 78.8 KiB postgresql-18-collection_1.1.0-1PIGSTY~bookworm_arm64.deb
postgresql-18-collection 1.1.0 d13.x86_64 pigsty 81.0 KiB postgresql-18-collection_1.1.0-1PIGSTY~trixie_amd64.deb
postgresql-18-collection 1.1.0 d13.aarch64 pigsty 78.9 KiB postgresql-18-collection_1.1.0-1PIGSTY~trixie_arm64.deb
postgresql-18-collection 1.1.0 u22.x86_64 pigsty 89.2 KiB postgresql-18-collection_1.1.0-1PIGSTY~jammy_amd64.deb
postgresql-18-collection 1.1.0 u22.aarch64 pigsty 88.5 KiB postgresql-18-collection_1.1.0-1PIGSTY~jammy_arm64.deb
postgresql-18-collection 1.1.0 u24.x86_64 pigsty 85.1 KiB postgresql-18-collection_1.1.0-1PIGSTY~noble_amd64.deb
postgresql-18-collection 1.1.0 u24.aarch64 pigsty 83.7 KiB postgresql-18-collection_1.1.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgcollection_17 1.1.0 el8.x86_64 pigsty 41.4 KiB pgcollection_17-1.1.0-1PIGSTY.el8.x86_64.rpm
pgcollection_17 1.1.0 el8.aarch64 pigsty 40.5 KiB pgcollection_17-1.1.0-1PIGSTY.el8.aarch64.rpm
pgcollection_17 1.1.0 el9.x86_64 pigsty 40.9 KiB pgcollection_17-1.1.0-1PIGSTY.el9.x86_64.rpm
pgcollection_17 1.1.0 el9.aarch64 pigsty 40.4 KiB pgcollection_17-1.1.0-1PIGSTY.el9.aarch64.rpm
pgcollection_17 1.1.0 el10.x86_64 pigsty 41.4 KiB pgcollection_17-1.1.0-1PIGSTY.el10.x86_64.rpm
pgcollection_17 1.1.0 el10.aarch64 pigsty 39.3 KiB pgcollection_17-1.1.0-1PIGSTY.el10.aarch64.rpm
postgresql-17-collection 1.1.0 d12.x86_64 pigsty 80.6 KiB postgresql-17-collection_1.1.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-collection 1.1.0 d12.aarch64 pigsty 78.5 KiB postgresql-17-collection_1.1.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-collection 1.1.0 d13.x86_64 pigsty 80.9 KiB postgresql-17-collection_1.1.0-1PIGSTY~trixie_amd64.deb
postgresql-17-collection 1.1.0 d13.aarch64 pigsty 78.5 KiB postgresql-17-collection_1.1.0-1PIGSTY~trixie_arm64.deb
postgresql-17-collection 1.1.0 u22.x86_64 pigsty 98.6 KiB postgresql-17-collection_1.1.0-1PIGSTY~jammy_amd64.deb
postgresql-17-collection 1.1.0 u22.aarch64 pigsty 98.2 KiB postgresql-17-collection_1.1.0-1PIGSTY~jammy_arm64.deb
postgresql-17-collection 1.1.0 u24.x86_64 pigsty 84.9 KiB postgresql-17-collection_1.1.0-1PIGSTY~noble_amd64.deb
postgresql-17-collection 1.1.0 u24.aarch64 pigsty 83.6 KiB postgresql-17-collection_1.1.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgcollection_16 1.1.0 el8.x86_64 pigsty 41.2 KiB pgcollection_16-1.1.0-1PIGSTY.el8.x86_64.rpm
pgcollection_16 1.1.0 el8.aarch64 pigsty 40.3 KiB pgcollection_16-1.1.0-1PIGSTY.el8.aarch64.rpm
pgcollection_16 1.1.0 el9.x86_64 pigsty 40.8 KiB pgcollection_16-1.1.0-1PIGSTY.el9.x86_64.rpm
pgcollection_16 1.1.0 el9.aarch64 pigsty 40.2 KiB pgcollection_16-1.1.0-1PIGSTY.el9.aarch64.rpm
pgcollection_16 1.1.0 el10.x86_64 pigsty 41.3 KiB pgcollection_16-1.1.0-1PIGSTY.el10.x86_64.rpm
pgcollection_16 1.1.0 el10.aarch64 pigsty 39.1 KiB pgcollection_16-1.1.0-1PIGSTY.el10.aarch64.rpm
postgresql-16-collection 1.1.0 d12.x86_64 pigsty 79.0 KiB postgresql-16-collection_1.1.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-collection 1.1.0 d12.aarch64 pigsty 77.1 KiB postgresql-16-collection_1.1.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-collection 1.1.0 d13.x86_64 pigsty 79.7 KiB postgresql-16-collection_1.1.0-1PIGSTY~trixie_amd64.deb
postgresql-16-collection 1.1.0 d13.aarch64 pigsty 77.3 KiB postgresql-16-collection_1.1.0-1PIGSTY~trixie_arm64.deb
postgresql-16-collection 1.1.0 u22.x86_64 pigsty 96.9 KiB postgresql-16-collection_1.1.0-1PIGSTY~jammy_amd64.deb
postgresql-16-collection 1.1.0 u22.aarch64 pigsty 96.3 KiB postgresql-16-collection_1.1.0-1PIGSTY~jammy_arm64.deb
postgresql-16-collection 1.1.0 u24.x86_64 pigsty 83.5 KiB postgresql-16-collection_1.1.0-1PIGSTY~noble_amd64.deb
postgresql-16-collection 1.1.0 u24.aarch64 pigsty 82.1 KiB postgresql-16-collection_1.1.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgcollection_15 1.1.0 el8.x86_64 pigsty 41.7 KiB pgcollection_15-1.1.0-1PIGSTY.el8.x86_64.rpm
pgcollection_15 1.1.0 el8.aarch64 pigsty 40.6 KiB pgcollection_15-1.1.0-1PIGSTY.el8.aarch64.rpm
pgcollection_15 1.1.0 el9.x86_64 pigsty 41.1 KiB pgcollection_15-1.1.0-1PIGSTY.el9.x86_64.rpm
pgcollection_15 1.1.0 el9.aarch64 pigsty 40.5 KiB pgcollection_15-1.1.0-1PIGSTY.el9.aarch64.rpm
pgcollection_15 1.1.0 el10.x86_64 pigsty 42.2 KiB pgcollection_15-1.1.0-1PIGSTY.el10.x86_64.rpm
pgcollection_15 1.1.0 el10.aarch64 pigsty 39.4 KiB pgcollection_15-1.1.0-1PIGSTY.el10.aarch64.rpm
postgresql-15-collection 1.1.0 d12.x86_64 pigsty 79.6 KiB postgresql-15-collection_1.1.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-collection 1.1.0 d12.aarch64 pigsty 76.8 KiB postgresql-15-collection_1.1.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-collection 1.1.0 d13.x86_64 pigsty 80.2 KiB postgresql-15-collection_1.1.0-1PIGSTY~trixie_amd64.deb
postgresql-15-collection 1.1.0 d13.aarch64 pigsty 76.8 KiB postgresql-15-collection_1.1.0-1PIGSTY~trixie_arm64.deb
postgresql-15-collection 1.1.0 u22.x86_64 pigsty 97.5 KiB postgresql-15-collection_1.1.0-1PIGSTY~jammy_amd64.deb
postgresql-15-collection 1.1.0 u22.aarch64 pigsty 97.0 KiB postgresql-15-collection_1.1.0-1PIGSTY~jammy_arm64.deb
postgresql-15-collection 1.1.0 u24.x86_64 pigsty 83.6 KiB postgresql-15-collection_1.1.0-1PIGSTY~noble_amd64.deb
postgresql-15-collection 1.1.0 u24.aarch64 pigsty 81.8 KiB postgresql-15-collection_1.1.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pgcollection_14 1.1.0 el8.x86_64 pigsty 41.7 KiB pgcollection_14-1.1.0-1PIGSTY.el8.x86_64.rpm
pgcollection_14 1.1.0 el8.aarch64 pigsty 40.6 KiB pgcollection_14-1.1.0-1PIGSTY.el8.aarch64.rpm
pgcollection_14 1.1.0 el9.x86_64 pigsty 41.0 KiB pgcollection_14-1.1.0-1PIGSTY.el9.x86_64.rpm
pgcollection_14 1.1.0 el9.aarch64 pigsty 40.5 KiB pgcollection_14-1.1.0-1PIGSTY.el9.aarch64.rpm
pgcollection_14 1.1.0 el10.x86_64 pigsty 41.6 KiB pgcollection_14-1.1.0-1PIGSTY.el10.x86_64.rpm
pgcollection_14 1.1.0 el10.aarch64 pigsty 39.4 KiB pgcollection_14-1.1.0-1PIGSTY.el10.aarch64.rpm
postgresql-14-collection 1.1.0 d12.x86_64 pigsty 79.7 KiB postgresql-14-collection_1.1.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-collection 1.1.0 d12.aarch64 pigsty 76.6 KiB postgresql-14-collection_1.1.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-collection 1.1.0 d13.x86_64 pigsty 80.3 KiB postgresql-14-collection_1.1.0-1PIGSTY~trixie_amd64.deb
postgresql-14-collection 1.1.0 d13.aarch64 pigsty 76.6 KiB postgresql-14-collection_1.1.0-1PIGSTY~trixie_arm64.deb
postgresql-14-collection 1.1.0 u22.x86_64 pigsty 97.3 KiB postgresql-14-collection_1.1.0-1PIGSTY~jammy_amd64.deb
postgresql-14-collection 1.1.0 u22.aarch64 pigsty 96.8 KiB postgresql-14-collection_1.1.0-1PIGSTY~jammy_arm64.deb
postgresql-14-collection 1.1.0 u24.x86_64 pigsty 83.5 KiB postgresql-14-collection_1.1.0-1PIGSTY~noble_amd64.deb
postgresql-14-collection 1.1.0 u24.aarch64 pigsty 81.5 KiB postgresql-14-collection_1.1.0-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/aws/pgcollection
 Source Tarball
pgcollection-1.1.0.tar.gz
 
pig build pkg pgcollection;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pgcollection;		# install via package name, for the active PG version
pig install collection;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION collection;
Last updated on
currencypgmp