Contents
cardinality
Note: Native PostgreSQL aggregation atop GIN indexes is omitted as it is unworkably slow on large datasets. ParadeDB also executes these queries faster than PostgreSQL using the columnar base scan (paradedb.enable_aggregate_custom_scan = off). Redundant base scan variants (basescan_group_by.sql and basescan_high_cardinality_group_by.sql) were pruned to keep benchmark execution fast, while basescan_distinct.sql is retained as a representative baseline for COUNT(DISTINCT ...).