Post Content
Understand how quorum-based consistency applies to cluster changes in Postgres. Jeremy Schneider (GEICO) and Leonardo Cecchi (EDB) explain this in their talk “Quorum-Based Consistency for Cluster Changes with CloudNativePG Operator” at POSETTE: An Event for Postgres 2026. Abstract: Most people don’t think of Postgres in the context of quorum or distributed systems theory but vanilla open source Postgres has supported quorum commits across multiple replicas for almost 10 years now. Technologies like cassandra and dynamo popularized quorum consistency in the hot path of distributed writes and reads, but the theory also applies to cluster reconfigurations in a single-writer database like Postgres. Stateful operators at level V of the capabilities framework require very careful end-to-end coordination between control plane and data plane algorithms to avoid data loss when providing auto-healing under circumstances like network partitions or compounded failures. This session will explore how quorum consistency can be applied in the CloudNativePG operator, offering insights to users of Postgres on Kubernetes about trusting Postgres to keep our data safe.
Jeremy Schneider has been programming for 30 years and working with databases for 20 years, first focused on Oracle and later focused on Postgres. He is currently an organizer of the Seattle Postgres User Group. He is also a Postgres Engineer at GEICO tech. Bringing his background with large-scale data processing and enterprise relational databases to the table, he is helping build a next-generation hybrid-cloud database platform.
Leonardo Cecchi, a principal in software development at EDB, plays a pivotal role as a maintainer in the CloudNativePG project and Biganimal, EDB’s DBaaS offering. With a longstanding preference for PostgreSQL dating back to 1998, his expertise in this DBMS is extensive. Before EDB acquired 2ndQuadrant, Leonardo worked as a developer and a PostgreSQL consultant. He is a founding member of the CloudNativePG project, which started in 2019.
► Video chapters:
⏩ 00:00 – Music & introduction
⏩ 00:28 – Running Postgres on Kubernetes
⏩ 01:25 – Why cluster management is external
⏩ 02:39 – Replication flexibility and trade-offs
⏩ 03:45 – Synchronous replication explained
⏩ 06:33 – Key Postgres replication parameters
⏩ 10:06 – Tuning durability, availability, performance
⏩ 12:34 – The failover correctness problem
⏩ 13:54 – Quorum-based failover design explained
⏩ 16:04 – Walking through failover scenarios
⏩ 19:11 – Introducing failoverquorum in CNPG
⏩ 22:00 – Ensuring config consistency with hashing
⏩ 25:02 – Real-world failover decision examples
⏩ 27:45 – Wrap-up and community contribution call
📕 Everything you need to know about POSETTE: An Event for Postgres can be found at: https://posetteconf.com
✅ Learn more: watch more POSETTE talks: https://aka.ms/posette-playlist
📌 Let’s connect:
LinkedIn: https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://x.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://aka.ms/posette-on-bluesky
#PosetteConf #PostgreSQL #Kubernetes Read More Microsoft Developer
