PostgreSQL Indexing Under Fire: B-Tree, BRIN, and Partial Indexes for 20M+ Rows
Optimize PostgreSQL for high-write workloads. How replacing B-Trees with BRIN and partial indexes saved 18 GB RAM and quadrupled ingestion throughput.
3 min read
#postgresql
#databases
#backend
#performance