TL;DR
PgDog, an open-source proxy that enables horizontal scaling for Postgres, has announced funding and is now accessible for deployment. It aims to solve Postgres’s scaling limitations and is already in active use.
PgDog, an open-source proxy designed to enable horizontal scaling of Postgres databases, has announced its funding and official availability for deployment. Developed by a small startup with extensive experience in scaling Postgres, the project aims to address the longstanding scaling challenges of traditional Postgres setups, making it suitable for large-scale applications.
The company behind PgDog reports that their system is already serving more than 2 million queries per second across dozens of deployments, including shards over 20 TB of data. PgDog operates as a proxy in front of Postgres, allowing users to deploy it on-premises, in cloud environments, or locally, with minimal setup—simply pulling their Docker image and updating the DATABASE_URL.
PgDog is open source and has seen over 1.4 million Docker pulls on GitHub. The startup has secured $5.5 million in funding from investors including Basis Set, YC, and Pioneer Fund, providing a strong financial runway. The team emphasizes that they built PgDog to scale Postgres, leveraging their experience from managing large-scale Postgres deployments at companies like Instacart. An upcoming Enterprise edition with SLA-backed support is also in development, aimed at easier deployment in AWS environments.
Impact of PgDog’s Funding and Deployment
This development is significant because it offers a practical solution to Postgres’s scaling limitations, potentially replacing other NoSQL databases like MongoDB or DynamoDB for large-scale applications. With its open-source model and active community, PgDog could influence how organizations deploy and manage large Postgres databases, making high performance accessible without proprietary constraints. The funding supports ongoing development and the upcoming enterprise support, which could accelerate adoption in enterprise environments, especially in cloud settings.
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 Existing Solutions
Postgres has traditionally been favored for its reliability and features, but its scaling capabilities have been limited, prompting the development of solutions like sharding and proxy layers. Companies like Instacart have previously addressed these issues by sharding Postgres across multiple environments, but these approaches often involve complex setups and custom solutions. PgDog aims to simplify this process by providing a scalable proxy that integrates seamlessly with existing Postgres instances, leveraging proven principles from high-scale deployments.
“PgDog is designed to make Postgres just work at any scale, whether on-prem or in the cloud.”
— an anonymous researcher
Step-by-Step FastAPI, React, and PostgreSQL Guide: A Beginner-Friendly Guide to Building and Deploying Full-Stack Applications with Docker, REST APIs, and Real Projects
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Unanswered Questions About PgDog’s Adoption
It is not yet clear how widely PgDog will be adopted outside of early deployments, or how it compares in performance and ease of use against existing solutions like Citus or other sharding proxies. The specifics of enterprise support, including SLA guarantees and compatibility with various cloud providers, are still in development. Additionally, the long-term stability and security of the system remain to be validated across diverse use cases.
Postgres sharding proxy
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Next Steps for PgDog’s Growth and Adoption
The company plans to release the enterprise edition with SLA-backed support soon, targeting larger organizations. They will continue weekly updates and community engagement through GitHub and Discord, aiming to expand user adoption and gather feedback. Monitoring real-world deployments and performance benchmarks will be critical to assess how well PgDog scales in different environments and workloads.
PostgreSQL Skills Development on Cloud: A Practical Guide to Database Management with AWS and Azure
As an affiliate, we earn on qualifying purchases.
As an affiliate, we earn on qualifying purchases.
Key Questions
How easy is it to deploy PgDog?
PgDog can be deployed quickly by pulling their Docker image, changing the DATABASE_URL, and running it, making it accessible for both small setups and large-scale deployments.
What are the key benefits of using PgDog?
PgDog offers horizontal scalability for Postgres, high query throughput, and flexibility to deploy in various environments without dependencies or hidden costs.
Is PgDog suitable for enterprise use?
The upcoming enterprise edition will include SLA-backed support, making it more suitable for large organizations with strict uptime and support requirements.
How does PgDog compare to other scaling solutions?
Unlike some existing solutions, PgDog is designed as a simple proxy that can be deployed anywhere, with a focus on high performance and ease of use, but comprehensive comparisons are still pending as adoption grows.
What is the long-term vision for PgDog?
The team aims to make Postgres just work at any scale, transforming how large-scale databases are managed and opening new possibilities for data-intensive applications.
Source: Hacker News
