Extensions
pgfaceting

pgfaceting

pgfaceting : fast faceting queries using an inverted index

Overview

ID Extension Package Version Category License Language
3580
pgfaceting
pgfaceting
 0.2.0
TYPE
BSD 3-Clause
SQL
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
----dt-
No
No
No
Yes
no
yes
Relationships
Requires
roaringbitmap
See Also
pg_trgm
rum
prefix
semver
unit
pgpdf
pglite_fusion
md5hash

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
MIXED
 0.2.0
18
17
16
15
14
13
 pgfaceting -
RPM
PIGSTY
 0.2.0
18
17
16
15
14
13
 pgfaceting_$v -
DEB
PGDG
 0.2.0
18
17
16
15
14
13
 postgresql-$v-pgfaceting -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el8.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el9.x86_64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el9.aarch64
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
PIGSTY 0.2.0
el10.x86_64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
el10.aarch64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
d12.x86_64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
d12.aarch64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
d13.x86_64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
d13.aarch64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
u22.x86_64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
u22.aarch64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
u24.x86_64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
u24.aarch64
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
PGDG 0.2.0
MISS
Package Version OS ORG SIZE File URL
pgfaceting_18 0.2.0 el8.x86_64 pigsty 14.6 KiB pgfaceting_18-0.2.0-1PIGSTY.el8.x86_64.rpm
pgfaceting_18 0.2.0 el8.x86_64 pgdg 15.5 KiB pgfaceting_18-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_18 0.2.0 el8.aarch64 pigsty 14.6 KiB pgfaceting_18-0.2.0-1PIGSTY.el8.aarch64.rpm
pgfaceting_18 0.2.0 el8.aarch64 pgdg 15.5 KiB pgfaceting_18-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_18 0.2.0 el9.x86_64 pigsty 14.4 KiB pgfaceting_18-0.2.0-1PIGSTY.el9.x86_64.rpm
pgfaceting_18 0.2.0 el9.x86_64 pgdg 15.3 KiB pgfaceting_18-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_18 0.2.0 el9.aarch64 pigsty 14.4 KiB pgfaceting_18-0.2.0-1PIGSTY.el9.aarch64.rpm
pgfaceting_18 0.2.0 el9.aarch64 pgdg 15.3 KiB pgfaceting_18-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_18 0.2.0 el10.x86_64 pgdg 15.8 KiB pgfaceting_18-0.2.0-1PGDG.rhel10.noarch.rpm
pgfaceting_18 0.2.0 el10.aarch64 pgdg 15.8 KiB pgfaceting_18-0.2.0-1PGDG.rhel10.noarch.rpm
postgresql-18-pgfaceting 0.2.0 d12.x86_64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-18-pgfaceting 0.2.0 d12.aarch64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-18-pgfaceting 0.2.0 d13.x86_64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-18-pgfaceting 0.2.0 d13.aarch64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-18-pgfaceting 0.2.0 u22.x86_64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-18-pgfaceting 0.2.0 u22.aarch64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-18-pgfaceting 0.2.0 u24.x86_64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
postgresql-18-pgfaceting 0.2.0 u24.aarch64 pgdg 9.7 KiB postgresql-18-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
Package Version OS ORG SIZE File URL
pgfaceting_17 0.2.0 el8.x86_64 pigsty 14.6 KiB pgfaceting_17-0.2.0-1PIGSTY.el8.x86_64.rpm
pgfaceting_17 0.2.0 el8.x86_64 pgdg 15.5 KiB pgfaceting_17-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_17 0.2.0 el8.aarch64 pigsty 14.6 KiB pgfaceting_17-0.2.0-1PIGSTY.el8.aarch64.rpm
pgfaceting_17 0.2.0 el8.aarch64 pgdg 15.5 KiB pgfaceting_17-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_17 0.2.0 el9.x86_64 pigsty 14.4 KiB pgfaceting_17-0.2.0-1PIGSTY.el9.x86_64.rpm
pgfaceting_17 0.2.0 el9.x86_64 pgdg 15.3 KiB pgfaceting_17-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_17 0.2.0 el9.aarch64 pigsty 14.4 KiB pgfaceting_17-0.2.0-1PIGSTY.el9.aarch64.rpm
pgfaceting_17 0.2.0 el9.aarch64 pgdg 15.3 KiB pgfaceting_17-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_17 0.2.0 el10.x86_64 pgdg 15.8 KiB pgfaceting_17-0.2.0-1PGDG.rhel10.noarch.rpm
pgfaceting_17 0.2.0 el10.aarch64 pgdg 15.8 KiB pgfaceting_17-0.2.0-1PGDG.rhel10.noarch.rpm
postgresql-17-pgfaceting 0.2.0 d12.x86_64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-17-pgfaceting 0.2.0 d12.aarch64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-17-pgfaceting 0.2.0 d13.x86_64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-17-pgfaceting 0.2.0 d13.aarch64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-17-pgfaceting 0.2.0 u22.x86_64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-17-pgfaceting 0.2.0 u22.aarch64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-17-pgfaceting 0.2.0 u24.x86_64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
postgresql-17-pgfaceting 0.2.0 u24.aarch64 pgdg 9.7 KiB postgresql-17-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
Package Version OS ORG SIZE File URL
pgfaceting_16 0.2.0 el8.x86_64 pigsty 14.6 KiB pgfaceting_16-0.2.0-1PIGSTY.el8.x86_64.rpm
pgfaceting_16 0.2.0 el8.x86_64 pgdg 15.5 KiB pgfaceting_16-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_16 0.2.0 el8.aarch64 pigsty 14.6 KiB pgfaceting_16-0.2.0-1PIGSTY.el8.aarch64.rpm
pgfaceting_16 0.2.0 el8.aarch64 pgdg 15.5 KiB pgfaceting_16-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_16 0.2.0 el9.x86_64 pigsty 14.4 KiB pgfaceting_16-0.2.0-1PIGSTY.el9.x86_64.rpm
pgfaceting_16 0.2.0 el9.x86_64 pgdg 15.3 KiB pgfaceting_16-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_16 0.2.0 el9.aarch64 pigsty 14.4 KiB pgfaceting_16-0.2.0-1PIGSTY.el9.aarch64.rpm
pgfaceting_16 0.2.0 el9.aarch64 pgdg 15.3 KiB pgfaceting_16-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_16 0.2.0 el10.x86_64 pgdg 15.8 KiB pgfaceting_16-0.2.0-1PGDG.rhel10.noarch.rpm
pgfaceting_16 0.2.0 el10.aarch64 pgdg 15.8 KiB pgfaceting_16-0.2.0-1PGDG.rhel10.noarch.rpm
postgresql-16-pgfaceting 0.2.0 d12.x86_64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-16-pgfaceting 0.2.0 d12.aarch64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-16-pgfaceting 0.2.0 d13.x86_64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-16-pgfaceting 0.2.0 d13.aarch64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-16-pgfaceting 0.2.0 u22.x86_64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-16-pgfaceting 0.2.0 u22.aarch64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-16-pgfaceting 0.2.0 u24.x86_64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
postgresql-16-pgfaceting 0.2.0 u24.aarch64 pgdg 9.7 KiB postgresql-16-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
Package Version OS ORG SIZE File URL
pgfaceting_15 0.2.0 el8.x86_64 pigsty 14.6 KiB pgfaceting_15-0.2.0-1PIGSTY.el8.x86_64.rpm
pgfaceting_15 0.2.0 el8.x86_64 pgdg 15.5 KiB pgfaceting_15-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_15 0.2.0 el8.aarch64 pigsty 14.6 KiB pgfaceting_15-0.2.0-1PIGSTY.el8.aarch64.rpm
pgfaceting_15 0.2.0 el8.aarch64 pgdg 15.5 KiB pgfaceting_15-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_15 0.2.0 el9.x86_64 pigsty 14.4 KiB pgfaceting_15-0.2.0-1PIGSTY.el9.x86_64.rpm
pgfaceting_15 0.2.0 el9.x86_64 pgdg 15.3 KiB pgfaceting_15-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_15 0.2.0 el9.aarch64 pigsty 14.4 KiB pgfaceting_15-0.2.0-1PIGSTY.el9.aarch64.rpm
pgfaceting_15 0.2.0 el9.aarch64 pgdg 15.3 KiB pgfaceting_15-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_15 0.2.0 el10.x86_64 pgdg 15.8 KiB pgfaceting_15-0.2.0-1PGDG.rhel10.noarch.rpm
pgfaceting_15 0.2.0 el10.aarch64 pgdg 15.8 KiB pgfaceting_15-0.2.0-1PGDG.rhel10.noarch.rpm
postgresql-15-pgfaceting 0.2.0 d12.x86_64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-15-pgfaceting 0.2.0 d12.aarch64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-15-pgfaceting 0.2.0 d13.x86_64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-15-pgfaceting 0.2.0 d13.aarch64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-15-pgfaceting 0.2.0 u22.x86_64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-15-pgfaceting 0.2.0 u22.aarch64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-15-pgfaceting 0.2.0 u24.x86_64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
postgresql-15-pgfaceting 0.2.0 u24.aarch64 pgdg 9.7 KiB postgresql-15-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
Package Version OS ORG SIZE File URL
pgfaceting_14 0.2.0 el8.x86_64 pigsty 14.6 KiB pgfaceting_14-0.2.0-1PIGSTY.el8.x86_64.rpm
pgfaceting_14 0.2.0 el8.x86_64 pgdg 15.5 KiB pgfaceting_14-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_14 0.2.0 el8.aarch64 pigsty 14.6 KiB pgfaceting_14-0.2.0-1PIGSTY.el8.aarch64.rpm
pgfaceting_14 0.2.0 el8.aarch64 pgdg 15.5 KiB pgfaceting_14-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_14 0.2.0 el9.x86_64 pigsty 14.4 KiB pgfaceting_14-0.2.0-1PIGSTY.el9.x86_64.rpm
pgfaceting_14 0.2.0 el9.x86_64 pgdg 15.3 KiB pgfaceting_14-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_14 0.2.0 el9.aarch64 pigsty 14.4 KiB pgfaceting_14-0.2.0-1PIGSTY.el9.aarch64.rpm
pgfaceting_14 0.2.0 el9.aarch64 pgdg 15.3 KiB pgfaceting_14-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_14 0.2.0 el10.x86_64 pgdg 15.8 KiB pgfaceting_14-0.2.0-1PGDG.rhel10.noarch.rpm
pgfaceting_14 0.2.0 el10.aarch64 pgdg 15.8 KiB pgfaceting_14-0.2.0-1PGDG.rhel10.noarch.rpm
postgresql-14-pgfaceting 0.2.0 d12.x86_64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-14-pgfaceting 0.2.0 d12.aarch64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg12+1_all.deb
postgresql-14-pgfaceting 0.2.0 d13.x86_64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-14-pgfaceting 0.2.0 d13.aarch64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg13+1_all.deb
postgresql-14-pgfaceting 0.2.0 u22.x86_64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-14-pgfaceting 0.2.0 u22.aarch64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg22.04+1_all.deb
postgresql-14-pgfaceting 0.2.0 u24.x86_64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
postgresql-14-pgfaceting 0.2.0 u24.aarch64 pgdg 9.7 KiB postgresql-14-pgfaceting_0.2.0-5.pgdg24.04+1_all.deb
Package Version OS ORG SIZE File URL
pgfaceting_13 0.2.0 el8.x86_64 pigsty 14.6 KiB pgfaceting_13-0.2.0-1PIGSTY.el8.x86_64.rpm
pgfaceting_13 0.2.0 el8.x86_64 pgdg 15.5 KiB pgfaceting_13-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_13 0.2.0 el8.aarch64 pigsty 14.6 KiB pgfaceting_13-0.2.0-1PIGSTY.el8.aarch64.rpm
pgfaceting_13 0.2.0 el8.aarch64 pgdg 15.5 KiB pgfaceting_13-0.2.0-1PGDG.rhel8.noarch.rpm
pgfaceting_13 0.2.0 el9.x86_64 pigsty 14.4 KiB pgfaceting_13-0.2.0-1PIGSTY.el9.x86_64.rpm
pgfaceting_13 0.2.0 el9.x86_64 pgdg 15.3 KiB pgfaceting_13-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_13 0.2.0 el9.aarch64 pigsty 14.4 KiB pgfaceting_13-0.2.0-1PIGSTY.el9.aarch64.rpm
pgfaceting_13 0.2.0 el9.aarch64 pgdg 15.3 KiB pgfaceting_13-0.2.0-1PGDG.rhel9.noarch.rpm
pgfaceting_13 0.2.0 el10.x86_64 pgdg 15.8 KiB pgfaceting_13-0.2.0-1PGDG.rhel10.noarch.rpm
pgfaceting_13 0.2.0 el10.aarch64 pgdg 15.8 KiB pgfaceting_13-0.2.0-1PGDG.rhel10.noarch.rpm

Source

Repository
github.com/cybertec-postgresql/pgfaceting
 Source Tarball
pgfaceting-0.2.0.tar.gz
 
pig build pkg pgfaceting;		# 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 pgfaceting;		# install via package name, for the active PG version

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

Create this extension with:

CREATE EXTENSION pgfaceting CASCADE; -- requires roaringbitmap
Last updated on
roaringbitmappg_sphere