pgfaceting

pig build pkg pgfaceting;		# build rpm

pig repo add pgsql -u   # add both repo and update cache

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

CREATE EXTENSION pgfaceting CASCADE; -- requires roaringbitmap

CREATE EXTENSION pgfaceting;

-- Create facet infrastructure for a table
SELECT pgfaceting.add_faceting_to_table(
    'products',
    'id',
    ARRAY[
        plain_facet('color'),
        plain_facet('size'),
        bucket_facet('price', ARRAY[0, 10, 50, 100, 500])
    ]
);

-- Run maintenance to merge incremental changes
SELECT pgfaceting.run_maintenance();

-- Merge deltas for a specific table
SELECT pgfaceting.merge_deltas('products');

-- Get top N facet values
SELECT pgfaceting.top_values('products', 10);

-- Count results with facet filters
SELECT pgfaceting.count_results('products', filters);