PgDog

What it does

PgDog is an open source connection pooler, load balancer, and sharding proxy for PostgreSQL. It combines three database infrastructure tools into a single executable that can be deployed anywhere. As a connection pooler, it can share a few Postgres connections among over 100,000 clients without breaking session state features like SET commands, advisory locks, and LISTEN/NOTIFY. As a load balancer, it distributes read queries across replicas with health checks and automatic failover detection, supporting read/write splitting via a Postgres SQL parser. As a distributed database proxy, it enables horizontal sharding without requiring application changes: it extracts sharding keys from queries and routes them to the correct shard, supports cross-shard transactions with two-phase commit, replicated tables for local joins, and automatic big integer primary keys. It also handles DDL migrations across shards transparently.

Who it is for

PgDog is designed for engineering teams that rely on PostgreSQL and need to scale beyond a single node without rewriting their application code. It is particularly useful for startups and mid-sized companies experiencing rapid growth where database connection limits, read traffic, or data volume become bottlenecks. The product is also suitable for enterprises that want to adopt PostgreSQL at scale while maintaining ACID compliance and minimizing operational complexity. The website highlights customers like Coinbase, Ramp, Modal, Span, TripStack, and others, indicating adoption among well-known tech companies.

Why it matters

Scaling PostgreSQL traditionally involves significant application changes, such as implementing client-side connection pooling, sharding logic, or custom load balancing. PgDog eliminates this friction by acting as a drop-in proxy that integrates without code changes. It addresses common pain points: connection limits with transaction mode pooling that preserves Postgres features (solving the “too many connections” problem), read scalability with automatic load balancing and failover, and data growth with a distributed database layer that supports OLTP and OLAP queries via scatter/gather. The product also maintains consistency with cross-shard transactions and supports standard tools like Alembic and ActiveRecord migrations. By consolidating three functions into one tool, it reduces infrastructure complexity and cost.

Launch signal

PgDog announced a $5.5 million seed round (the exact date is not specified, but the website includes a link to a funding announcement). It launched on Product Hunt on the day of this profile creation (based on the snippet “Launching today”). The product is open source and hosted on GitHub, with docs and installation instructions available. The website features testimonials from engineers at Ramp, Modal, and other companies, indicating real-world production use at scale (e.g., “20 TB+ sharded, 2 M+ queries/s in production”).

Brand and naming

The name “PgDog” is playful and memorable, leveraging the common “Pg” abbreviation for PostgreSQL and “Dog” to suggest a loyal, hardworking companion. The domain pgdog.dev is short and brandable. The tagline “Scale PostgreSQL without changing your app” clearly positions the product as a zero-friction scaling solution, reinforced by the website’s emphasis on being a drop-in proxy. The naming effectively targets developers but may not immediately convey the full scope of features (pooling, balancing, sharding) without additional context.