/blog / series/postgresql-performance-series
$ PostgreSQL Performance Series
3 posts, in reading order
Getting real performance out of PostgreSQL under load: table partitioning that actually prunes, advanced indexing beyond the default B-tree — partial, covering, GIN and BRIN — and scaling strategies proven on high-transaction-volume fintech workloads.
$ Posts in this series
6 min read
PostgreSQL Data Partitioning
Range, list and hash partitioning in PostgreSQL: how each splits a table, what the planner does with the partition key, and what it costs later.
3 min read
PostgreSQL Index Types: B-tree, GiST, Partial and Expression
Which PostgreSQL index to reach for: B-tree defaults, bitmap scans, GiST for non-scalar data, and the partial and expression indexes that shrink them.
4 min read
Scaling PostgreSQL for High Transaction Volumes in Fintech
Strategies for scaling PostgreSQL in fintech: improve transaction throughput, query performance and availability while preserving consistency and integrity.