TL;DR
PgDog, an open-source scalable Postgres proxy, has received funding and is now available for deployment. It aims to address Postgres’s scaling limitations, with proven performance in production. Details about enterprise features and future plans are still emerging.
PgDog, an open-source project designed to make Postgres horizontally scalable, has announced securing funding and is now available for deployment across various environments, including cloud, on-premises, and local machines.
The project, developed by a small startup, has raised $5.5 million from investors including Basis Set, YC, and Pioneer Fund. PgDog functions as a proxy in front of Postgres, enabling it to handle over 2 million queries per second and shard over 20 TB of data in production environments, according to the developers.
Designed by infrastructure engineers with extensive experience scaling Postgres at companies like Instacart, PgDog aims to address the longstanding scaling challenges of Postgres, which is often limited by its architecture. The project is open source, with over 1.4 million Docker pulls on GitHub, and releases occur weekly.
The developers plan to build an enterprise edition with SLA-backed support, focusing on easier deployment in cloud environments like AWS, and are actively engaging with their community via Discord for support and development feedback.
Why Funding and Launch Are Major for Postgres Scaling
This development is significant because it could enable Postgres to serve large-scale applications that currently rely on more complex or less mature solutions like MongoDB or DynamoDB. By providing a scalable, open-source proxy, PgDog could transform how organizations deploy and manage Postgres at scale, potentially reducing reliance on proprietary or cloud-specific databases. The funding provides resources to accelerate development and enterprise features, making Postgres more accessible for enterprise use cases and large data workloads.
PostgreSQL: Programmazione avanzata (Programmare con Python) (Italian Edition)
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Postgres Scaling Challenges and Prior Efforts
Postgres has historically been limited by its architecture, which makes horizontal scaling difficult. While solutions like sharding and replication exist, they often require complex setups and are not seamless for users. The rise of NoSQL databases like MongoDB and cloud-native solutions like DynamoDB has been partly driven by the need for scalable data stores.
In recent years, various efforts have aimed to improve Postgres scalability, but none have achieved the level of performance claimed by PgDog. The project’s approach of using a proxy to shard and distribute queries in real-time is a notable innovation, drawing on the team’s extensive experience in scaling Postgres at high-volume companies.
“PgDog is designed to make Postgres just work at any scale, with no dependencies or hidden costs.”
— an anonymous researcher
Truper Expert Post Hole Digger, 48-Inch Fiberglass Handles with Cushion Grips, Heavy-Duty Steel Blades, Professional Grade Fencing and Landscaping Tool (Model CA-38F / 11982)
HEAVY-DUTY STEEL BLADES: High-strength steel blades are designed to maintain a sharp edge and resist bending during deep…
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Unconfirmed Details About Enterprise Features
While the open-source version of PgDog is now available, details about the upcoming enterprise edition, including SLA support and cloud-specific integrations, have not been fully disclosed. It is not yet clear when the enterprise features will be released or how they will be priced.
MYSQL MASTERY FOR DATABASE ENGINEERS: 45 Practical Solutions for Tuning, Scaling & Managing High-Volume Data
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Next Steps for PgDog and User Adoption
The team plans to release the enterprise edition with support options soon and will continue to develop and improve the open-source proxy. Community engagement through Discord suggests active support and ongoing development. Users interested in scaling Postgres are encouraged to test the current version and follow updates for enterprise offerings.
PostgreSQL 18 for Developers: Build High-Performance Databases with SQL, Database Design, Query Optimization, JSONB, Security, Docker, Cloud Deployment, and Hands-On Projects
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Key Questions
How does PgDog improve Postgres scalability?
PgDog acts as a proxy that shards and distributes queries across multiple Postgres instances, enabling horizontal scaling and high query throughput.
Can I deploy PgDog on any environment?
Yes, PgDog can be deployed on-premises, in the cloud, or locally, with simple configuration changes using Docker images.
Is PgDog open source?
Yes, PgDog is fully open source, with over 1.4 million Docker pulls on GitHub, and it receives weekly updates.
When will the enterprise version be available?
The team has announced plans to develop an enterprise edition with SLA-backed support, but specific release dates have not been disclosed yet.
What are the main benefits of using PgDog?
It allows Postgres to handle large-scale workloads with high query rates, improves scalability, and provides deployment flexibility without vendor lock-in.
Source: Hacker News
