~/writing

Postgresql

2 posts tagged postgresql. clear filter

October 2026
  • 13
    Replica lag and read-your-writes
    day 27 · Distributed Systems in 30 Days

    You'll learn how read-replica lag breaks read-your-writes for AI agents, how to measure it, and how to fix it with session pinning, causal tokens, staleness budgets and idempotent agent tools.

September 2026
  • 13
    Why adding a database index didn't speed up reads
    day 11 · One Concept a Day — The AI-Era Engineer's Glossary

    An agent diagnosed a slow dashboard query, shipped a confident CREATE INDEX, and made nothing faster except the growth of our busiest table's write bill — here's the one command that would've caught it before it merged.