Latest / More than a refresh: Conversations with the most interesting people you've never met
MTAR T3D Sessions: Why PostgreSQL’s Extended Query Protocol Complicates Caching
Serving a query from cache gets more complicated when PostgreSQL still needs to know which statements have been prepared and bound. For James Nelson, founder and CTO of PgCache, keeping that state consistent is what makes the extended query protocol his Postgres pet peeve.
In this installment of Postgres Pet Peeves, James explains how his caching proxy tracks prepared statements and forwards preparation messages to PostgreSQL when they become necessary. A wrong message or response can put the connection out of sync and cause it to be terminated. He and JD explore that coordination work, along…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.