Welcome to the Day3 of PG19 Hacktober!! If you’ve run PostgreSQL in production, you’ve probably watched autovacuum spend hours on
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 »
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 »
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 »
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 »
Introduction: Have you ever faced a situation where a PostgreSQL query that usually finishes in a few seconds suddenly starts taking
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 »
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 »
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 »
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 »
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 »
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 »
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
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 »
Production PostgreSQL deployments demand high availability. Applications requiring four or five nines of uptime need resilient database clusters built on
Postgres HA Architecture: Eliminating SPoF with Keepalived Read Post »
At OpenSource DB, we often talk about optimization not as a buzzword but as a mindset. While most think of
Service and Technology Optimization: Simplifying for Better Outcomes Read Post »
