In Part 1 of our PostgreSQL MVCC Internals series, we explored one of Postgres’s fundamental architectural designs: rows are never […]
PostgreSQL MVCC Internals – Part 2: How PostgreSQL Decides Which Row Version You Can See Read Post »
In Part 1, we explored what pglogical is, how it works internally, and why it plays such an important role
Part 2: pglogical – Flexible Logical Replication for PostgreSQL Read Post »
Introduction PostgreSQL is well known for its rock-solid replication features. For many workloads, physical replication works just fine. But as
Part 1: pglogical – Flexible Logical Replication for PostgreSQL Read Post »
Imagine a scenario: You are a DBA at a large-scale e-commerce company. Your primary database hasgrown to 10 million rows
Selective Row-Level Filtering in PostgreSQL Logical Replication Read Post »
Introduction In this blog, I’ll share my experience in performing the data migration of an entire Oracle database to Postgres
Oracle to PostgreSQL Data Migration Using Ora2Pg: Full Load Read Post »
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 »
plpgsql_check extension Plpgsql_check is a powerful postgres extension that acts as a linter and validator for pl/pgsql functions, catching bugs
Syntax Is Not Enough: Catching Hidden Semantic Errors in PostgreSQL with plpgsql_check Read Post »
If you have ever tuned a PostgreSQL instance, the first parameter you likely touched was shared_buffers. This block of memory
Understanding Dynamic Shared Memory (DSM) in PostgreSQL Read Post »
In Part 1 and Part 2 of pg_search: Modern Full-Text Search Inside PostgreSQL, we explored the architecture, motivation, and performance
BM25 in PostgreSQL: Modern Relevance Ranking and the Growing Search Ecosystem Read Post »
Introduction: Performance optimization is a core responsibility of every DBA. In a production environment, tuning a database requires a structured
Performance Optimization And Replication in PostgreSQL Read Post »
pg_search is a PostgreSQL extension developed by ParadeDB that enhances native PostgreSQL full-text search capabilities by introducing a high-performance BM25-based
pg_search: Modern Full-Text Search Inside PostgreSQL : Part 1 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 »
Introduction In day-to-day database operations, a key responsibility of a DBA is to monitor database health, handle performance issues, and
Understanding Database Performance Based on Query Behavior Read Post »
Our journey to PGConf India has officially begun! Starting today, we’re launching a daily blog series that will run every
Memory management is crucial to the performance of PostgreSQL databases. How PostgreSQL allocates and utilizes memory directly impacts query speed,
Exploring the depths of PostgreSQL’s Memory: A Practical Guide to pg_buffercache Read Post »
Do Postgres have Global Temporary Table in the same way that Oracle and SQL Server do ? No, PostgreSQL does
Implementing Global Temporary Tables in PostgreSQL with pgtt Read Post »
Logical replication is one of the most fascinating internals of PostgreSQL. Unlike physical replication, which works at the block level,
One Tuple, Many Steps : Inside PostgreSQL Logical Replication Read Post »
For years, PostgreSQL logical replication has been the go-to for data distribution and zero-downtime upgrades. But it has always had
PostgreSQL 18: Breaking the Conflict Deadlock in Logical Replication 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 »
If you have ever tried to bulk-load millions of rows into a database and watched it crawl because of foreign
The PostgreSQL superpower you should use with caution: session_replication_role Read Post »
