PG19 Hacktober: 31 Days of New Features: pg_plan_advice: Taking the Wheel of the PostgreSQL Planner
Welcome to the 11th blog post of PG19 Hacktober. In database performance, query planning is a critical piece of the
PG19 Hacktober: 31 Days of New Features:REPACK: ONE COMMAND TO REPLACE VACUUM FULL AND CLUSTER WITH NEW CONCURRENTLY
PostgreSQL 19 introduces the native REPACK command, combining the capabilities of VACUUM FULL and CLUSTER while supporting CONCURRENTLY for reduced
PG19 Hacktober: 31 Days of New Features: Autovacuum Grows Up: Parallel Workers and the New Table-Priority Scoring System
Welcome to the Day3 of PG19 Hacktober!! If you’ve run PostgreSQL in production, you’ve probably watched autovacuum spend hours on
Data Synchronization Between DC and DR Using pg_rewind – Part 2
In part-1 of the blog series, we demonstrated how PostgreSQL pg_rewind can be used to resynchronize an old primary (dc01) server after
Data Synchronization Between DC and DR Using pg_rewind – Part 2 Read Post »
Introduction to pg_timetable – An Advanced PostgreSQL Job Scheduler
When I started learning about PostgreSQL job schedulers, I came across tools like pg_cron and pgAgent. These tools are useful
Introduction to pg_timetable – An Advanced PostgreSQL Job Scheduler Read Post »
Data Synchronization Between DC and DR Using pg_rewind – Part 1
Introduction: We recently encountered a scenario with one of our customers during a PostgreSQL DR drill. As part of the
Data Synchronization Between DC and DR Using pg_rewind – Part 1 Read Post »
Resolving a Patroni “System ID Mismatch” Error: A Complete Troubleshooting Guide
If you run PostgreSQL high-availability clusters with Patroni, sooner or later you’ll run into a message like this in your
Resolving a Patroni “System ID Mismatch” Error: A Complete Troubleshooting Guide Read Post »
How PostgreSQL Temporary Files Affect Query Performance and How work_mem Optimization Improves It
Introduction: Have you ever faced a situation where a PostgreSQL query that usually finishes in a few seconds suddenly starts taking
Part 2: pglogical – Flexible Logical Replication for PostgreSQL
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 »
Selective Row-Level Filtering in PostgreSQL Logical Replication
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 »
Oracle to PostgreSQL Data Migration Using Ora2Pg: Full Load
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 »
When a Disk Expansion Brought Down a PostgreSQL Archive Pipeline
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 »
What Production Teams Need to Know About May ‘26 Postgres Minor releases
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 »
pg_search: Modern Full-Text Search Inside PostgreSQL : Part 1
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 »
PostgreSQL Failover in Action: Testing VIP Management and Split-Brain Detection Without Keepalived
Our journey to PGConf India has officially begun! Starting today, we’re launching a daily blog series that will run every
Exploring the depths of PostgreSQL’s Memory: A Practical Guide to pg_buffercache
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 »
One Tuple, Many Steps : Inside PostgreSQL Logical Replication
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 »
Battle-Tested: Being a PostgreSQL DBA
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 »
Optimizing PostgreSQL Delete Operations: A Deep Dive into Performance Troubleshooting
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 »
Production-Ready Selective Logical Replication: Non-Partitioned to Partitioned Tables in PostgreSQL
In modern database architectures, it’s common to maintain separate environments for transactional operations and analytical workloads. One challenging scenario is
Understanding Subqueries in PostgreSQL- Part 1
Subqueries, often called nested queries or inner queries, are a powerful feature in SQL that allow you to execute one
Understanding Subqueries in PostgreSQL- Part 1 Read Post »