select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Features

hll

type for storing hyperloglog data

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packagehll
Version2.21
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars1,229
Latest commit2026-06-02
Latest release2026-08-03
Catalogue updated2026-08-30

Related extensions

See also

count_distinctAn alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
datasketchesApproximate analytics sketches and aggregates for PostgreSQL
omnisketchdata structure for on-line agg of data into approximate sketch
topntype for top-n JSONB
ddsketchProvides ddsketch aggregate function
tdigestProvides tdigest aggregate function.
roaringbitmapsupport for Roaring Bitmaps
bloombloom access method - signature file based index
rumRUM index access method
pgfacetingfast faceting queries using an inverted index