Supercharge Your PostgreSQL with ProxySQL
The ProxySQL team is heading to PGConf India 2026 in Bengaluru as a gold sponsor, and we’re bringing a full hands-on tutorial: Supercharge Your PostgreSQL: A Hands-On Guide to High Availability and Connection Pooling with ProxySQL.
Stop by our booth and talk to the team about the 7 must-haves in 2026 for scaling PostgreSQL clusters without downtime.
About the Tutorial
As PostgreSQL deployments scale for always-on applications, three critical challenges consistently emerge: managing connection overhead, ensuring high availability, and optimising query traffic. This 3-hour workshop addresses all three — from first principles through to a production-ready configuration.
Starting from a standard primary/replica PostgreSQL setup, participants progressively build a robust, highly available, and scalable database layer using ProxySQL as the central control point.
What You Will Learn
- Intelligent connection pooling — eliminate connection overhead and protect backends from connection storms
- Read/write splitting — route writes to the primary and reads to replicas automatically, without application changes
- Query routing — direct specific queries to the right backend based on pattern matching and user context
- Query firewalling — block or rewrite dangerous queries before they reach the database
- Automated failover detection — detect primary failure and promote replicas with minimal disruption
Who This Is For
Engineering and DBA teams running PostgreSQL at scale who want a battle-tested, open-source proxy layer that solves the hard operational problems — without touching application code or the database itself.
Hands-On Examples
All lab exercises from the tutorial are available at github.com/proxysql/tutorials so you can follow along or revisit the material after the event.
Visit the Booth
If you are attending PGConf India 2026, come find us. The ProxySQL team will be on hand to discuss connection pooling strategies, high availability architectures, and anything else PostgreSQL and ProxySQL.
We look forward to seeing you in Bengaluru.