Address Tough Database Challenges
Reduce response times and deliver better experiences while improving reliability and availability
Before pgEdge
With pgEdge
Faster page loads. Superior customer experience.
Low data latency
Greatly reduce the latency of long round-trip response times due to a single monolithic database by placing copies of your database close to your users. For web applications where a compelling customer experience with short page load times is essential, deploying pgEdge is a game changer. While edge platforms like Cloudflare, Fastly and Vercel make it easy to place presentation and compute logic at or near the network edge, pgEdge lets you put your data and database there too.
Consider a SaaS application or e-commerce site with users across North America and Europe. With a single read/write copy of the database in a single cloud region (e.g. Northern Virginia) users far away from that cloud region experience long page load times. With even a simple 3-node pgEdge configuration with nodes in the Eastern US, Western US and Europe page load times for users in the Western US and Europe will be dramatically reduced.
Ultra high availability with failover between cloud regions.
Ultra-high availability
The multi-active (multi-master) architecture of pgEdge inherently supports ultra high availability in a simple and straight-forward fashion. If one or more nodes go down traffic immediately fails over to the remaining active nodes. There’s no delay or lost transactions while previously passive nodes take a vote to decide on a new single active node. With pgEdge, disaster recovery and failover are built in, and easy to architect for and deploy. Unlike other high availability solutions pgEdge makes it much easier to support failover between cloud regions. For certain critical applications saying “sorry, but our cloud provider’s Eastern region is down” is simply not acceptable. And the best part: zero downtime for maintenance!
For many companies implementing cross region or even cross cloud failover has been prohibitively difficult and expensive due to monolithic database architectures. pgEdge Distributed PostgreSQL takes the complexity out of implementing cross-region and cross-cloud failover strategies.
Meet data residency requirements for global and local data.
Data residency
Increasingly international regulations and/or customers require that data generated by citizens of a country or region are stored only in that country or region. With pgEdge you can control which tables are globally replicated, and which stay local. In addition you can implement geographic sharding, or “geo-sharding”, where tables are broken out based on a location field (like “country”). This shares global data globally, while keeping local data local where necessary.
For example, an e-commerce company might globally replicate product catalog data, while keeping customer information and the order data they generate within a geographic region like Europe or the United States.
Geographic sharding improves user response times.
Geographic scale-out
Using the geographic sharding capabilities of pgEdge supports the geographic scale-out of applications, particularly when Postgres workloads threaten to exceed available compute capacity. While also supporting higher throughput this approach improves response times and user experience by putting the database closer to end users.
JAMStack Applications
pgEdge is designed to meet the requirements of modern web application developers who are building applications using the JAMStack architecture. pgEdge integrates with edge development platforms from companies such as Cloudflare, Fastly, Netlify, Akamai, Vercel and others. While these platforms have made it easy to move presentation and compute closer to the network edge, pgEdge makes it easy to put databases at or near the edge.
Learn how to access a pgEdge distributed database cluster from within Cloudflare Workers.
Dive deeper into pgEdge
Distributed PostgreSQL Buyer's Guide: How to evaluate vendor claims of Postgres compatibility
Get started today.
Experience the magic of pgEdge Distributed PostgreSQL now.