PgDog
To be verifiedScale PostgreSQL without changing your app
WebsiteFreeWeb AppAPI
Overall score
—(0 reviews)
pgdog.dev/
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.
Feature Comparison
A functional comparison based on maker input.
To be verified.
Comparison details are provided for informational purposes and should be verified with the official website.
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.
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.
Why is it fantastic?
No review tags yet.
What can be improved?
No review tags yet.
Frequently Asked Questions
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.