brin-index

Here are 3 public repositories matching this topic...

postgis-python / spatial-index-advisor

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

waqastarar883 / postgresql-10m-performance-demo

Star

2000x query speedup on 10M rows using BRIN indexes. Full EXPLAIN ANALYZE benchmarks. PostgreSQL 16.

sql postgresql performance-optimization database-optimization brin-index explain-analyze

Updated Jan 29, 2026

shariff199 / uk-land-registry-sql

Star

31,430,611 UK property sales in PostgreSQL. Kensington medians are 8.4x Burnley, the new-build premium is a flats artefact, and a 128 kB BRIN beats a 211 MB B-tree by 3.3x.

python sql etl postgresql open-data data-analysis query-optimization land-registry uk brin-index

Updated Aug 26, 2026
Shell

Improve this page

Add a description, image, and links to the brin-index topic page so that developers can more easily learn about it.

Curate this topic

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."

Learn more