/blog / #database-performance
#database-performance
3 posts
$ Related series
· 4 min
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.
4 min
· 3 min
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.
3 min
· 6 min
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.
6 min