PostgreSQL HA Risks, Replication Internals, & Rapid Branching Today's...
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
Today's Highlights
Today's highlights include critical insights into Patroni's replication slot management, an architectural deep dive into PostgreSQL's synchronous commit behavior, and a look at achieving sub-second database branching for enhanced developer workflows.
When Patroni Silently Deletes Your Replication Slots (Planet PostgreSQL)
Source: https://postgr.es/p/9lM
Using PostgreSQL's built-in logical replication slots with row filters and publication column lists (PG15+) to selectively…
Deep dive into pg_try_advisory_xact_lock for leader election and job claiming in multi-instance deployments, covering lock…
During a reliability gameday, Datadog engineers discovered that their PostgreSQL clusters couldn’t safely fail over. Here’s how…
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns Today's...
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture ...
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's...
