PgDog - Postgres Scaling Without App Rewrites

Scale Postgres n times with zero app changes

Unclaimed

Updated Jul 2026 · Added Jul 2026

pgdog.dev

Database ToolsFreedatabase-tools

Visit Pgdog

Share: X in LinkedIn

Add your screenshot here

Image or video shown in this spot

What is Pgdog?

PgDog is a PostgreSQL proxy that combines connection pooling, load balancing, and distributed database sharding in a single executable. It enables horizontal scaling of Postgres without requiring application changes, handling 2M+ queries/second and 20TB+ sharded data in production. Designed for teams needing to scale Postgres infrastructure while maintaining ACID compliance and full SQL compatibility.

Explore Pgdog

Need help implementing PgDog - Postgres Scaling Without App Rewrites?

Find verified specialists who work with PgDog - Postgres Scaling Without App Rewrites

Browse specialists

Key Features of Pgdog

Connection pooler with real transaction mode
Load balancer for read/write splitting
Distributed database sharding without app changes
Health checks and automatic failover detection
Cross-shard ACID transactions
Parallel query execution across shards
Support for OLTP and OLAP operations
Flexible configuration-driven data distribution
Compatible with all PostgreSQL client drivers
Deployable via Helm, Docker, or standalone binary

Who Should Use Pgdog?

Scale PostgreSQL horizontally for high-traffic applications

Distribute read queries across replica databases

Implement database sharding without application rewrites

Manage failover and primary detection automatically

Pool thousands of client connections efficiently

Execute distributed transactions across multiple shards

Optimize database performance for OLTP and OLAP workloads

Pgdog: Pros & Cons

✓Pros

Drop-in proxy requiring no application code changes
Supports 50,000+ transactions per second per thread
Maintains ACID compliance at scale
Handles 100,000+ concurrent clients with minimal connections
Automatic health checks and failover detection
Flexible sharding configuration
Compatible with standard PostgreSQL client libraries
Deployable anywhere (Helm, Docker, or standalone)
Supports complex distributed operations like GROUP BY and JOIN across shards

Frequently Asked Questions about Pgdog

What is PgDog?

PgDog is a PostgreSQL proxy that combines connection pooling, load balancing, and distributed database sharding in a single executable, enabling horizontal scaling of Postgres without requiring application changes.

Does PgDog require changes to my application?

No, PgDog is a drop-in proxy that works with all PostgreSQL client drivers and requires zero application changes.

What performance can PgDog achieve?

PgDog can handle 2M+ queries per second and manages 20TB+ sharded databases in production, with 50,000+ transactions per second per thread.

Does PgDog maintain data consistency?

Yes, PgDog maintains full ACID compliance, including support for cross-shard transactions with automatic rollback on errors using native PostgreSQL prepared transactions.

How can I deploy PgDog?

PgDog can be deployed via Helm, Docker, or as a standalone binary and is compatible with major orchestration platforms.