PgDog

Overview

PgDog is a high-performance, open-source clustering middleware and proxy designed specifically for PostgreSQL. Written in Rust, it acts as a connection pooler, read-replicas load balancer, and database sharder without requiring application code changes. It preserves full session state compatibility, supports cross-shard atomic transactions, and handles heavy workloads efficiently. By sitting transparently between apps and databases, it scales Postgres infrastructure seamlessly.

Founder story

PgDog was founded by Lev Kokotov, a technical founder with extensive background scaling large database systems at companies like Instacart. Recognizing the limitations of existing PostgreSQL routing and connection tools, the creator built a fast, extension-free Rust proxy to handle transparent sharding, load balancing, and connection pooling under heavy production traffic.

What it does

• - Multiplexes thousands of client connections over a tiny pool of Postgres server connections using real transaction mode
• - Distributes read queries across replicas and handles automatic primary failover detection like an application load balancer
• - Automatically routes queries and shards data across multiple databases without requiring database extensions or application rewrites
• - Executes atomic cross-shard transactions utilizing native Postgres prepared transactions and two-phase commit protocols.

Who it's for

• Postgres Operators
• Platform Engineering Teams
• SaaS Builders and Founders
• Backend Software Engineers

Why it works

• Open-source licensing model ensures total transparency, community contribution, and free self-hosted deployment
• Eliminates leaky abstractions by supporting native session states, SET commands, and advisory locks without connection pinning
• Written in Rust to deliver multi-threaded, asynchronous performance capable of handling massive query throughput safely
• Requires zero application code modifications or proprietary database extensions to achieve horizontal sharding.

Growth strategies

• Open- source distribution via GitHub repository and Docker container registries
• Show HN and technical community launches targeting high- growth engineering teams
• Word- of-mouth adoption among developers hitting database connection and scaling limits
• Documentation- led growth focused on seamless drop-in replacement for traditional poolers

Alternatives

• PgBouncer
• Citus
• RDS Proxy
• HAProxy

Comparison overview

• Traditional tools like PgBouncer introduce leaky abstractions that break session state features or require application rewrites.
• PgDog provides built-in query parsing, transparent sharding, and real transaction mode pooling while maintaining full Postgres compliance.