postgresql-hll ☆
« Back to VersTracker
Description:
PostgreSQL extension adding HyperLogLog data structures as a native data type
Type: Formula  |  Latest Version: 2.19@0  |  Tracked Since: Oct 17, 2025
Links: Homepage  |  @citusdata  |  formulae.brew.sh
Category: Databases
Tags: postgresql extension hyperloglog database analytics
Install: brew install postgresql-hll
About:
This Homebrew formula installs the PostgreSQL extension for HyperLogLog (HLL), enabling approximate distinct counting directly within the database. It provides a native `hll` data type and associated functions, allowing users to estimate cardinality over massive datasets with minimal memory usage. This is ideal for real-time analytics where exact counts are computationally prohibitive.
Key Features:
  • Native HyperLogLog data type for PostgreSQL
  • Memory-efficient approximate distinct counting
  • Set operations (union, intersection) on HLL structures
  • Functions for converting to/from bitmaps
Use Cases:
  • Real-time user analytics (e.g., counting unique daily visitors)
  • Large-scale data deduplication and cardinality estimation
  • Network traffic monitoring (counting unique IPs)
Alternatives:
  • postgresql – Standard PostgreSQL requires exact counting which consumes significantly more memory and CPU for large datasets.
Version History
Detected Version Rev Change Commit
Oct 17, 2025 8:25pm 0 VERSION_BUMP 146dc11e
Sep 16, 2025 2:51pm 0 VERSION_BUMP 15753bd4
« Back to VersTracker  |  Browse Packages  |  About