$ tag: #postgresql

$ Posts in this tag

• 2026-09-08·15 min readNEW

  The Read Side Does Not Go Through the Aggregate

  CQRS read models in Symfony 8: a read port the domain does not own, a query bus that returns a value, and when a projection table earns its place. Part 3.

  DDD, CQRS and Hexagonal Architecture in Symfony 8 · part 3#cqrs#ddd#hexagonal-architecture#symfony#php#postgresql#doctrine

• 2026-07-14·21 min read

  Building Idempotent Message Handlers in Symfony Messenger

  A production guide to idempotent Symfony Messenger handlers using SQS, Redis locks, PostgreSQL deduplication, and the Outbox Pattern.

  #symfony#messenger#idempotency#amazon-sqs#redis#postgresql#kubernetes#outbox

• 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