Extensions
hll

hll

hll : type for storing hyperloglog data

Overview

ID Extension Package Version Category License Language
2770
hll
hll
 2.18
FEAT
Apache-2.0
C++
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
topn
count_distinct
omnisketch
bloom
roaringbitmap
ddsketch
tdigest
citus

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 2.18
18
17
16
15
14
13
 hll -
RPM
PGDG
 2.18
18
17
16
15
14
13
 hll_$v* -
DEB
PGDG
 2.18
18
17
16
15
14
13
 postgresql-$v-hll -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 2.19
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
el8.aarch64
PGDG 2.19
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
el9.x86_64
PGDG 2.19
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
el9.aarch64
PGDG 2.19
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
el10.x86_64
PGDG 2.19
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
el10.aarch64
PGDG 2.19
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
PGDG 2.18
d12.x86_64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
d12.aarch64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
d13.x86_64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
d13.aarch64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
u22.x86_64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
u22.aarch64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
u24.x86_64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
u24.aarch64
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
PGDG 2.19
Package Version OS ORG SIZE File URL
hll_18 2.19 el8.x86_64 pgdg 42.4 KiB hll_18-2.19-1PGDG.rhel8.x86_64.rpm
hll_18 2.19 el8.aarch64 pgdg 42.1 KiB hll_18-2.19-1PGDG.rhel8.aarch64.rpm
hll_18 2.19 el9.x86_64 pgdg 42.1 KiB hll_18-2.19-1PGDG.rhel9.x86_64.rpm
hll_18 2.19 el9.aarch64 pgdg 41.9 KiB hll_18-2.19-1PGDG.rhel9.aarch64.rpm
hll_18 2.19 el10.x86_64 pgdg 42.5 KiB hll_18-2.19-1PGDG.rhel10.x86_64.rpm
hll_18 2.19 el10.aarch64 pgdg 41.9 KiB hll_18-2.19-1PGDG.rhel10.aarch64.rpm
postgresql-18-hll 2.19 d12.x86_64 pgdg 76.5 KiB postgresql-18-hll_2.19-1.pgdg12+1_amd64.deb
postgresql-18-hll 2.19 d12.aarch64 pgdg 75.6 KiB postgresql-18-hll_2.19-1.pgdg12+1_arm64.deb
postgresql-18-hll 2.19 d13.x86_64 pgdg 76.4 KiB postgresql-18-hll_2.19-1.pgdg13+1_amd64.deb
postgresql-18-hll 2.19 d13.aarch64 pgdg 75.6 KiB postgresql-18-hll_2.19-1.pgdg13+1_arm64.deb
postgresql-18-hll 2.19 u22.x86_64 pgdg 76.3 KiB postgresql-18-hll_2.19-1.pgdg22.04+1_amd64.deb
postgresql-18-hll 2.19 u22.aarch64 pgdg 75.2 KiB postgresql-18-hll_2.19-1.pgdg22.04+1_arm64.deb
postgresql-18-hll 2.19 u24.x86_64 pgdg 75.0 KiB postgresql-18-hll_2.19-1.pgdg24.04+1_amd64.deb
postgresql-18-hll 2.19 u24.aarch64 pgdg 74.0 KiB postgresql-18-hll_2.19-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hll_17 2.18 el8.x86_64 pgdg 41.8 KiB hll_17-2.18-2PGDG.rhel8.x86_64.rpm
hll_17 2.18 el8.aarch64 pgdg 41.4 KiB hll_17-2.18-2PGDG.rhel8.aarch64.rpm
hll_17 2.18 el9.x86_64 pgdg 41.9 KiB hll_17-2.18-2PGDG.rhel9.x86_64.rpm
hll_17 2.18 el9.aarch64 pgdg 41.8 KiB hll_17-2.18-2PGDG.rhel9.aarch64.rpm
hll_17 2.18 el10.x86_64 pgdg 42.1 KiB hll_17-2.18-3PGDG.rhel10.x86_64.rpm
hll_17 2.18 el10.aarch64 pgdg 41.6 KiB hll_17-2.18-3PGDG.rhel10.aarch64.rpm
postgresql-17-hll 2.19 d12.x86_64 pgdg 76.6 KiB postgresql-17-hll_2.19-1.pgdg12+1_amd64.deb
postgresql-17-hll 2.19 d12.aarch64 pgdg 75.5 KiB postgresql-17-hll_2.19-1.pgdg12+1_arm64.deb
postgresql-17-hll 2.19 d13.x86_64 pgdg 76.5 KiB postgresql-17-hll_2.19-1.pgdg13+1_amd64.deb
postgresql-17-hll 2.19 d13.aarch64 pgdg 75.6 KiB postgresql-17-hll_2.19-1.pgdg13+1_arm64.deb
postgresql-17-hll 2.19 u22.x86_64 pgdg 82.7 KiB postgresql-17-hll_2.19-1.pgdg22.04+1_amd64.deb
postgresql-17-hll 2.19 u22.aarch64 pgdg 81.6 KiB postgresql-17-hll_2.19-1.pgdg22.04+1_arm64.deb
postgresql-17-hll 2.19 u24.x86_64 pgdg 75.1 KiB postgresql-17-hll_2.19-1.pgdg24.04+1_amd64.deb
postgresql-17-hll 2.19 u24.aarch64 pgdg 74.0 KiB postgresql-17-hll_2.19-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hll_16 2.18 el8.x86_64 pgdg 41.7 KiB hll_16-2.18-1PGDG.rhel8.x86_64.rpm
hll_16 2.18 el8.aarch64 pgdg 41.3 KiB hll_16-2.18-1PGDG.rhel8.aarch64.rpm
hll_16 2.18 el9.x86_64 pgdg 41.6 KiB hll_16-2.18-1PGDG.rhel9.x86_64.rpm
hll_16 2.18 el9.aarch64 pgdg 41.8 KiB hll_16-2.18-1PGDG.rhel9.aarch64.rpm
hll_16 2.18 el10.x86_64 pgdg 42.1 KiB hll_16-2.18-3PGDG.rhel10.x86_64.rpm
hll_16 2.18 el10.aarch64 pgdg 41.6 KiB hll_16-2.18-3PGDG.rhel10.aarch64.rpm
postgresql-16-hll 2.19 d12.x86_64 pgdg 76.6 KiB postgresql-16-hll_2.19-1.pgdg12+1_amd64.deb
postgresql-16-hll 2.19 d12.aarch64 pgdg 75.5 KiB postgresql-16-hll_2.19-1.pgdg12+1_arm64.deb
postgresql-16-hll 2.19 d13.x86_64 pgdg 76.5 KiB postgresql-16-hll_2.19-1.pgdg13+1_amd64.deb
postgresql-16-hll 2.19 d13.aarch64 pgdg 75.5 KiB postgresql-16-hll_2.19-1.pgdg13+1_arm64.deb
postgresql-16-hll 2.19 u22.x86_64 pgdg 82.3 KiB postgresql-16-hll_2.19-1.pgdg22.04+1_amd64.deb
postgresql-16-hll 2.19 u22.aarch64 pgdg 81.1 KiB postgresql-16-hll_2.19-1.pgdg22.04+1_arm64.deb
postgresql-16-hll 2.19 u24.x86_64 pgdg 75.1 KiB postgresql-16-hll_2.19-1.pgdg24.04+1_amd64.deb
postgresql-16-hll 2.19 u24.aarch64 pgdg 74.0 KiB postgresql-16-hll_2.19-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hll_15 2.18 el8.x86_64 pgdg 42.0 KiB hll_15-2.18-1PGDG.rhel8.x86_64.rpm
hll_15 2.17 el8.x86_64 pgdg 89.5 KiB hll_15-2.17-1.rhel8.x86_64.rpm
hll_15 2.18 el8.aarch64 pgdg 41.6 KiB hll_15-2.18-1PGDG.rhel8.aarch64.rpm
hll_15 2.17 el8.aarch64 pgdg 89.2 KiB hll_15-2.17-1.rhel8.aarch64.rpm
hll_15 2.18 el9.x86_64 pgdg 41.9 KiB hll_15-2.18-1PGDG.rhel9.x86_64.rpm
hll_15 2.17 el9.x86_64 pgdg 90.6 KiB hll_15-2.17-1.rhel9.x86_64.rpm
hll_15 2.18 el9.aarch64 pgdg 41.9 KiB hll_15-2.18-1PGDG.rhel9.aarch64.rpm
hll_15 2.17 el9.aarch64 pgdg 91.1 KiB hll_15-2.17-1.rhel9.aarch64.rpm
hll_15 2.18 el10.x86_64 pgdg 43.1 KiB hll_15-2.18-3PGDG.rhel10.x86_64.rpm
hll_15 2.18 el10.aarch64 pgdg 42.7 KiB hll_15-2.18-3PGDG.rhel10.aarch64.rpm
postgresql-15-hll 2.19 d12.x86_64 pgdg 77.0 KiB postgresql-15-hll_2.19-1.pgdg12+1_amd64.deb
postgresql-15-hll 2.19 d12.aarch64 pgdg 76.0 KiB postgresql-15-hll_2.19-1.pgdg12+1_arm64.deb
postgresql-15-hll 2.19 d13.x86_64 pgdg 76.9 KiB postgresql-15-hll_2.19-1.pgdg13+1_amd64.deb
postgresql-15-hll 2.19 d13.aarch64 pgdg 76.0 KiB postgresql-15-hll_2.19-1.pgdg13+1_arm64.deb
postgresql-15-hll 2.19 u22.x86_64 pgdg 83.1 KiB postgresql-15-hll_2.19-1.pgdg22.04+1_amd64.deb
postgresql-15-hll 2.19 u22.aarch64 pgdg 82.2 KiB postgresql-15-hll_2.19-1.pgdg22.04+1_arm64.deb
postgresql-15-hll 2.19 u24.x86_64 pgdg 76.1 KiB postgresql-15-hll_2.19-1.pgdg24.04+1_amd64.deb
postgresql-15-hll 2.19 u24.aarch64 pgdg 75.5 KiB postgresql-15-hll_2.19-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hll_14 2.18 el8.x86_64 pgdg 42.0 KiB hll_14-2.18-1PGDG.rhel8.x86_64.rpm
hll_14 2.16 el8.x86_64 pgdg 90.0 KiB hll_14-2.16-1.rhel8.x86_64.rpm
hll_14 2.18 el8.aarch64 pgdg 41.6 KiB hll_14-2.18-1PGDG.rhel8.aarch64.rpm
hll_14 2.17 el8.aarch64 pgdg 89.0 KiB hll_14-2.17-1.rhel8.aarch64.rpm
hll_14 2.18 el9.x86_64 pgdg 41.9 KiB hll_14-2.18-1PGDG.rhel9.x86_64.rpm
hll_14 2.18 el9.aarch64 pgdg 41.9 KiB hll_14-2.18-1PGDG.rhel9.aarch64.rpm
hll_14 2.17 el9.aarch64 pgdg 90.9 KiB hll_14-2.17-1.rhel9.aarch64.rpm
hll_14 2.18 el10.x86_64 pgdg 43.1 KiB hll_14-2.18-3PGDG.rhel10.x86_64.rpm
hll_14 2.18 el10.aarch64 pgdg 42.8 KiB hll_14-2.18-3PGDG.rhel10.aarch64.rpm
postgresql-14-hll 2.19 d12.x86_64 pgdg 76.9 KiB postgresql-14-hll_2.19-1.pgdg12+1_amd64.deb
postgresql-14-hll 2.19 d12.aarch64 pgdg 75.8 KiB postgresql-14-hll_2.19-1.pgdg12+1_arm64.deb
postgresql-14-hll 2.19 d13.x86_64 pgdg 76.8 KiB postgresql-14-hll_2.19-1.pgdg13+1_amd64.deb
postgresql-14-hll 2.19 d13.aarch64 pgdg 75.9 KiB postgresql-14-hll_2.19-1.pgdg13+1_arm64.deb
postgresql-14-hll 2.19 u22.x86_64 pgdg 83.1 KiB postgresql-14-hll_2.19-1.pgdg22.04+1_amd64.deb
postgresql-14-hll 2.19 u22.aarch64 pgdg 82.2 KiB postgresql-14-hll_2.19-1.pgdg22.04+1_arm64.deb
postgresql-14-hll 2.19 u24.x86_64 pgdg 76.1 KiB postgresql-14-hll_2.19-1.pgdg24.04+1_amd64.deb
postgresql-14-hll 2.19 u24.aarch64 pgdg 75.4 KiB postgresql-14-hll_2.19-1.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hll_13 2.18 el8.x86_64 pgdg 41.5 KiB hll_13-2.18-1PGDG.rhel8.x86_64.rpm
hll_13 2.15 el8.x86_64 pgdg 88.4 KiB hll_13-2.15-1.rhel8.x86_64.rpm
hll_13 2.18 el8.aarch64 pgdg 41.5 KiB hll_13-2.18-1PGDG.rhel8.aarch64.rpm
hll_13 2.17 el8.aarch64 pgdg 88.7 KiB hll_13-2.17-1.rhel8.aarch64.rpm
hll_13 2.18 el9.x86_64 pgdg 41.8 KiB hll_13-2.18-1PGDG.rhel9.x86_64.rpm
hll_13 2.18 el9.aarch64 pgdg 41.9 KiB hll_13-2.18-1PGDG.rhel9.aarch64.rpm
hll_13 2.17 el9.aarch64 pgdg 90.7 KiB hll_13-2.17-1.rhel9.aarch64.rpm
hll_13 2.18 el10.x86_64 pgdg 43.1 KiB hll_13-2.18-3PGDG.rhel10.x86_64.rpm
hll_13 2.18 el10.aarch64 pgdg 42.7 KiB hll_13-2.18-3PGDG.rhel10.aarch64.rpm
postgresql-13-hll 2.19 d12.x86_64 pgdg 76.5 KiB postgresql-13-hll_2.19-1.pgdg12+1_amd64.deb
postgresql-13-hll 2.19 d12.aarch64 pgdg 75.7 KiB postgresql-13-hll_2.19-1.pgdg12+1_arm64.deb
postgresql-13-hll 2.19 d13.x86_64 pgdg 76.8 KiB postgresql-13-hll_2.19-1.pgdg13+1_amd64.deb
postgresql-13-hll 2.19 d13.aarch64 pgdg 75.7 KiB postgresql-13-hll_2.19-1.pgdg13+1_arm64.deb
postgresql-13-hll 2.19 u22.x86_64 pgdg 82.8 KiB postgresql-13-hll_2.19-1.pgdg22.04+1_amd64.deb
postgresql-13-hll 2.19 u22.aarch64 pgdg 81.8 KiB postgresql-13-hll_2.19-1.pgdg22.04+1_arm64.deb
postgresql-13-hll 2.19 u24.x86_64 pgdg 76.2 KiB postgresql-13-hll_2.19-1.pgdg24.04+1_amd64.deb
postgresql-13-hll 2.19 u24.aarch64 pgdg 75.0 KiB postgresql-13-hll_2.19-1.pgdg24.04+1_arm64.deb

Source

Repository
github.com/citusdata/postgresql-hll

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install hll;		# install via package name, for the active PG version

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

Create this extension with:

CREATE EXTENSION hll;
Last updated on
agerum