PostgreSQL Indexing Under Fire: B-Tree, BRIN, and Partial Indexes for 20M+ Rows
Stop putting standard B-Trees on every column. How swapping to BRIN and partial expression indexes saved 18 GB of RAM and 4x’d ingestion throughput on a production cluster.
3 min read
#postgresql
#databases
#backend
#performance