pgdogdev/pgdog v0.1.18

on GitHub

What's changed

• feat: support subqueries in SELECT and DELETE for finding the sharding key (next week, UPDATE and INSERT will be added as well)
• feat: support forcing load balancer to use the primary for all queries using a connection parameter (pgdog.role=primary)
• fix: connection pool leaked when servers were left in a dirty state and was opening more connections than configured max
• fix: handle SET and SET LOCAL correctly inside transactions
• fix: search_path-based routing for schema-based sharding improvements
• fix: remove unnecessary mutex acquisition in the connection pool: small 2-3% performance improvement when the pool is at capacity
• fix: remove recursion limit from pg_query parser, supporting complex queries for read/write split and sharding
• chore: logging improvements to debug connection creation / closure; helps with configuration changes

Full Changelog: v0.1.17...v0.1.18