/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
One of the features that make PostgreSQL stand out is its built-in support for data partitioning. Data partitioning is a technique used to…
3 min read
Unlock the Power of PostgreSQL: Master Advanced Indexing Options for Optimal Query Performance
Maximize your PostgreSQL database performance with advanced indexing options. Learn the latest techniques and best practices for…
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.