2000x query speedup on 10M rows using BRIN indexes. Full EXPLAIN ANALYZE benchmarks. PostgreSQL 16.
-
Updated
Jan 29, 2026
#
brin-index
Here are 2 public repositories matching this topic...
Analyses PostgreSQL query workloads and PostGIS table statistics, then recommends spatial indexes — GiST, SP-GiST, BRIN, partial, composite — plus clustering, index drops and query rewrites. Reads pg_stat_statements exports, CSV logs or plain SQL, ranks findings by a documented heuristic cost model, and emits ready-to-review DDL.
postgresql gis postgis spatial-index query-optimization pg-stat-statements brin-index sqlglot database-performance dba-tools gist-index
-
Updated
Jul 19, 2026 - Python
Improve this page
Add a description, image, and links to the brin-index topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the brin-index topic, visit your repo's landing page and select "manage topics."