PostgreSQL 19’s optimizer work targets two limits: rewrites the planner couldn’t prove safe, and plans it couldn’t see. NULL semantics
Welcome to Day 1 of PG19 Hacktober, following last year’s PG18 Hacktober. Every day this October we’ll take a new
A Community Gathering Where PostgreSQL Internals Meet AI Innovation Hyderabad PGDays 2026 is bringing the PostgreSQL community together on August
PGDays Hyderabad 2026: PostgreSQL, AI & the Future of Data Read Post »
If you run PostgreSQL in production at any scale, you’ve probably already adopted Patroni to manage high availability within a
If you run PostgreSQL at scale with Patroni, you’ve probably hit the point where every replica streaming directly from the
Production database incidents rarely look like what you expect. They don’t arrive with sirens. They accumulate quietly — a mount
When a Disk Expansion Brought Down a PostgreSQL Archive Pipeline Read Post »
The CVEs That Matter Most in Production 🔴 Critical: Path Traversal in pg_basebackup & pg_rewind (CVE-2026-6475) Who’s hit: Anyone running
What Production Teams Need to Know About May ‘26 Postgres Minor releases Read Post »
Welcome to our latest blog!! In the real world, not every PostgreSQL deployment gives you the freedom to choose your
Setting Up Logical Replication on PostgreSQL (Windows) Read Post »
Every engineering org eventually runs into this conversation. A production incident fires, connection errors start flooding the logs, and someone
Who Owns Connection Pooling? The App Team vs. DB Team Debate Read Post »
PostgreSQL logical replication is a powerful feature — elegant in concept, battle-hardened in design. But when we push it to
Terabyte-Scale PostgreSQL Logical Replication: The Challenges nobody warns us about Read Post »
In the high-stakes world of High Availability (HA), meticulous performance tuning, and mission-critical production systems, veteran Database Administrators and System
PostgreSQL gives you excellent streaming replication. You can have a primary node streaming WAL (Write-Ahead Log) to one or more
How Patroni Brings High Availability to PostgreSQL Read Post »
At the heart of what we do is a deep belief that great technology thrives in great communities. That’s why
Building Bridges with the PostgreSQL Community: Our Journey Read Post »
When multiple users try to update the same data simultaneously, chaos could ensue without proper coordination. PostgreSQL’s row-level locking mechanism
Understanding PostgreSQL Row-Level Locking: A Practical Guide Read Post »
Our journey to PGConf India has officially begun! Starting today, we’re launching a daily blog series that will run every
We all know that Repmgr (Replication Manager) is an open-source tool designed to manage PostgreSQL replication and facilitate automatic failover.
Understanding Repmgr Architecture: Fencing & VIP Management Challenges Read Post »
Being a PostgreSQL DBA means living in a world where production issues don’t arrive on a schedule. Over the past
Battle-Tested: Being a PostgreSQL DBA Read Post »
There’s a moment in every database team’s journey when the usual PostgreSQL tuning advice stops working. Your shared_buffers are optimized.
From Gigabytes to Terabytes: The PostgreSQL Survival Guide Read Post »
Our client was experiencing frustratingly slow delete operations in their PostgreSQL database. What should have been a monthly data cleanup
Optimizing PostgreSQL Delete Operations: A Deep Dive into Performance Troubleshooting Read Post »
In modern database architectures, it’s common to maintain separate environments for transactional operations and analytical workloads. One challenging scenario is
As we close out 2025, we’re thrilled to reflect on an incredible year of knowledge sharing, community building, and technical
A Year of PostgreSQL Excellence – OSDB’s Blogging Journey Read Post »
