Jul 19, 2026

PgDog

Scale PostgreSQL without changing your app
AI WritingContent GenerationResearchEmail WritingSummarizationRewritingAcademic ResearchBrowser Extension

Overview
What is PgDog?

PgDog is an open-source connection pooler, load balancer, and sharding proxy for PostgreSQL that enables horizontal scaling without changing your application code.

Scale PostgreSQL without changing your app

Core Features
Connection pooling: share a few Postgres connections among 100,000+ clients while preserving session state, advisory locks, and LISTEN/NOTIFY.
Multi-threaded and async: handles 50,000+ transactions per second per thread with no query length or connection limits.
Read/write splitting: automatically routes SELECT queries to replicas and other queries to the primary, using Postgres SQL parser.
Sharding: distributes data across shards based on a sharding key, supports cross-shard transactions, replicated tables, and automatic DDL propagation.
Health checks and failover detection: blocks outdated or broken replicas and moves write traffic to a new primary without config changes.
ACID compliance: maintains consistency at scale with native two-phase commit and automatic rollback on errors.
Popular Use Cases
  • Scaling PostgreSQL for high-traffic web applications without application changes.
  • Distributing read queries across replicas to improve performance and reduce load.
  • Sharding large databases to handle growing data volumes while maintaining relational integrity.
  • Building a distributed, consistent database layer for OLTP and OLAP workloads.
  • Simplifying database infrastructure with a single endpoint for connection pooling, load balancing, and sharding.
How to use
  • Download the PgDog executable from the official website or GitHub.
  • Configure the proxy with your PostgreSQL connection details and desired settings (pool size, sharding rules, etc.).
  • Deploy PgDog as a standalone service or alongside your application.
  • Point your application's database connection to the PgDog endpoint instead of directly to PostgreSQL.
  • Monitor performance and scaling through logs and health checks.
Product Timeline
To be verified
Pricing
PgDog uses a Free pricing model. Pricing and features may change over time.
Free
$0
To be verified
Pro
To be verified
To be verified
Team
To be verified
To be verified
Enterprise
To be verified
To be verified
Deal / Coupon
No coupon listed.
Verification
Tool status
To be verified
Pricing verified
To be verified
Founder claimed
No / To be verified
Source
Official website / Community submitted
Related Tags
AI WritingContent GenerationResearchEmail WritingSummarizationRewritingAcademic ResearchBrowser ExtensionFreemium
Own this tool?
Claim this profile to update product information, pricing, and official answers.