PostgreSQL
Wire protocols, connection state, database incidents, and compatibility from the inside out.
browse this topic
PostgreSQL essays
5 essays
2026
-
Reassembling Postgres from the wire Decoding a protocol as a passive observer rather than an endpoint: userspace TCP reassembly with holes you can never fill, a decoder that has to be a state machine, and a typed filter language that evaluates without allocating. -
A flight recorder for Postgres Why database incidents stay unexplained, what aviation figured out about that decades ago, and the design thinking behind Tracegres: incidents should be reconstructable, not anecdotal. -
Prepared statements vs connection pools Part three of speaking fluent PostgreSQL: why the query that works locally dies behind pgbouncer, explained from the wire up, and every fix ranked.
2025
-
Faking pg_catalog Part two of speaking fluent PostgreSQL: the system catalog is the real compatibility surface. What psql and every GUI tool actually ask, the five tables that carry the load, and how to build a catalog shim from captured traffic instead of guesswork. -
Speaking fluent PostgreSQL What implementing the Postgres wire protocol from three directions taught me: the startup dance, the two protocols hiding inside it, why transactions are the hard part, and the compatibility lies every Postgres-compatible database must tell.
Nothing matched that search. Try a technology, topic, or shorter phrase.