Source: pg-sift Section: database Priority: optional Maintainer: Braulio Oliveira Build-Depends: debhelper-compat (= 13), postgresql-server-dev-@PG@, liblz4-dev, libzstd-dev, libicu-dev Standards-Version: 4.7.0 Homepage: https://github.com/brauliobo/pg_sift Package: postgresql-@PG@-pg-sift Architecture: any Depends: postgresql-@PG@, ${misc:Depends}, ${shlibs:Depends} Description: Fast analytics for PostgreSQL: just add an index, plus BM25 full-text search pg_sift answers counts, sums, distinct counts, group-bys and top-N from compressed columns, with the queries you already have: a sift_col index on a table, or the sift_table table access method, is picked by the planner through the SiftAgg aggregate scan, and a query the planner cannot prove equal keeps PostgreSQL's own plan. . It also adds BM25 full-text search: a sift index answers boolean, phrase, prefix, wildcard, regex and fuzzy queries with exact ranking, through its own query syntax. . One CREATE EXTENSION, no shared_preload_libraries. For PostgreSQL 17, 18 and 19.