News for hackers. Stuff that matters.
Re:Scalable PostgreSQL Connection Pooler by tsenart on Friday November 12, 2021 @05:36PM (#29205334)
This, please! Native support for read-replicas would be awesome. Ideally it would now if a query is read-only or not without application changes.
Re:Scalable PostgreSQL Connection Pooler by jpgvm on Friday November 12, 2021 @08:36PM (#29206523)
For a variety of reasons this is incredibly difficult. Functions, etc make SELECT queries writes, not just UPDATE/DELETE, etc.

It's a lot easier for your application to know what a write is and just establish connections to 2 separate poolers (or hosts on the same poolers) and direct the reads/writes appropriately.

Re:Scalable PostgreSQL Connection Pooler by x4m on Saturday November 13, 2021 @12:28AM (#29207663)
There's already working part of libpq protocol for this - target_session_attrs. But the problem with target_session_attrs is that it just takes too long to discover new primary after failolver. We want to fix this within Odyssey.