pgEdge Distributed PostgreSQL

@pgEdgeDistributedPostgres
8 Followers
30 Following
34 Posts

pgEdge Distributed PostgreSQL helps companies achieve high availability and reduced data latency, all while ensuring that data that must stay local remains local. Only pgEdge is multi-master, multi-region and multi-cloud, while being fully based on standard Postgres and 100% open (source available).

pgEdgeβ€˜s Distributed PostgreSQL offers fully managed cloud or self-hosted options. Visit www.pgedge.com to download or learn more.

Websitehttps://www.pgedge.com/
Discordhttps://discord.com/invite/pgedge/login
Try pgEdge Cloud free for 30 dayshttps://www.pgedge.com/get-started/cloud

Shaun Thomas just released a new #PostgreSQL extension that increases max_wal_size if there are too many forced checkpoints over checkpoint_timeout. As per his description, it's "like having a tiny DBA as an extension" 🐘

Base max_wal_size on system activity rather than a randomly selected number. Achieve better database performance for high write loads. All with the power of #OpenSource πŸš€

https://github.com/pgedge/pg_walsizer

#Postgres #data #oss #foss #tech #dev #developer #database

GitHub - pgEdge/pg_walsizer: The pg_walsizer Postgres Extension

The pg_walsizer Postgres Extension. Contribute to pgEdge/pg_walsizer development by creating an account on GitHub.

GitHub

Psst: there's also new updates for pgEdge Cloud! ☁️ Some highlights:

πŸ‘‰ Multi-Availability Zone support for improved fault tolerance
πŸ‘‰ All performance & conflict-handling improvements from Platform v25
πŸ‘‰ A clean SOC 2 Type II certification, reinforcing our commitment to security & operational excellence

Whether self-managed or fully hosted, pgEdge now offers even more flexible & resilient options for #PostgreSQL deployments.

πŸ“° Learn more: https://hubs.la/Q03DzvRK0

#postgres #tech #dev #database

pgEdge

Fully distributed PostgreSQL

pgEdge Platform v25 is released with the new Spock 5 replication engine! Key improvements:

πŸ‘‰ Zero-downtime node additions
πŸ‘‰ Improved exception handling
πŸ‘‰ Expanded automatic conflict resolution

and more!

Get the details: https://www.pgedge.com/press-releases/pgedge-announces-release-of-pgedge-platform-v25

#Postgres #DBA #data #azure #aws #gcp #rds

Our new #Helm chart makes deploying distributed #PostgreSQL easier than ever.

Two deployment patterns: single #K8s cluster for testing (fast setup, minimal networking) or multi-region active-active with #Cilium networking.

The ACE consistency engine automatically detects and repairs #data drift across nodes. Built on #PostgreSQL 15+, works with existing tooling, full multi-master replication with DDL sync.

Get up and running in minutes. πŸš€

https://www.pgedge.com/blog/getting-started-with-the-pgedge-helm-chart-for-distributed-postgresql

#dev #foss #dba #tech

#Postgres DBAs: cold page reads eating up query execution time on full table scans?

Some config params that help reduce I/O latency by 40%:

effective_io_concurrency = 200 (SSDs)
random_page_cost = 1.1
max_parallel_workers = 8

These changes (and others!) resulted in a 30% improvement in checksum time. Explore our latest blog for before/after EXPLAIN ANALYZE output + explanations behind each param at the DB and OS level.

https://www.pgedge.com/blog/optimising-cold-page-reads-in-postgresql

#tech #data #SQL #oracle #mysql #sqlserver #DBA

91% of enterprises require 99.99% uptimeβ€”yet 1 in 5 experienced a cloud region failure in the past year.

With 82% expressing concern, cloud resiliency is clearly top of mind.

Explore what IT leaders are doing to prepare in our PostgreSQL HA survey:
πŸ‘‰ https://www.pgedge.com/PostgresHAsurvey

#cloud #iot #education #finance #data #database #azure #aws #gcp

How do you solve AI latency across continents without breaking consistency? πŸ’‘

Enquire AI's case study shows the shift from traditional primary-replica to multi-master PostgreSQL architecture. The twist: pgvector + distributed nodes = local inference instead of cross-continent data shuttling. 🐘 🌐

Check out the full report on the AI Journal for the implementation details:

πŸ“– https://aijourn.com/delivering-on-low-latency-edge-ai-with-distributed-postgresql/

#EdgeAI #PostgreSQL #IoT #tech #vector #ai #ml #saas #developer #data #aijournal

What are you using to manage failover within your #PostgreSQL deployments? According to the latest survey conducted by Foundry, built-in cloud provider solutions are top of the list - even though 21% of the respondents also directly experienced cloud region failure in the last year. πŸ€”

See what else enterprises are doing to address failover in the published survey results:
πŸ‘‰ https://www.pgedge.com/PostgresHAsurvey

#Postgres #SQL #data #datascience #edgeai #cloud #dataanalytics #iot #saas

#PostgreSQL is no longer just emergingβ€”it’s embedded. 🐘

βœ… 37% of enterprises run mission-critical apps on #Postgres
βœ… 30% are standardizing it across most workloads

Explore what’s driving widespread enterprise adoption in the full survey:
πŸ‘‰ https://www.pgedge.com/PostgresHAsurvey

#database #tech #dev #enterprise #developer #edgenetworks

πŸš€ The latest Foundry survey of 212 IT decision-makers across enterprises and SaaS businesses found that 91 percent of organizations currently using PostgreSQL demand no more than four minutes of downtime per month, or around 99.99 percent uptime, while 24 percent aim for less than 30 seconds.

Learn more from co-founder and CEO of pgEdge, Phillip Merrick, in this article from the Register:

https://www.theregister.com/2025/07/22/postgresql_hyperscalers_gartner/

#PostgreSQL #TheRegister #pgEdge #CloudComputing #OpenSource #Gartner

Customers fret about downtime with hyperscalers' PostgreSQL services

Analysis: Smaller vendors offering alternatives cash in concerns

The Register
Γ—

#PostgreSQL is no longer just emergingβ€”it’s embedded. 🐘

βœ… 37% of enterprises run mission-critical apps on #Postgres
βœ… 30% are standardizing it across most workloads

Explore what’s driving widespread enterprise adoption in the full survey:
πŸ‘‰ https://www.pgedge.com/PostgresHAsurvey

#database #tech #dev #enterprise #developer #edgenetworks