$ tag: #database-performance

$ Posts in this tag

• 2023-08-22·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.

  PostgreSQL Performance Series · part 3#postgresql#fintech#database-performance

• 2023-01-26·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.

  PostgreSQL Performance Series · part 2#postgresql#database-performance

• 2023-01-17·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.

  PostgreSQL Performance Series · part 1#postgresql#database-performance