Building Bridges with the PostgreSQL Community: Our Journey
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 »
pg_search: Modern Full-Text Search Inside PostgreSQL: Part 2
In Part 1, we explored the architectural design, motivation, performance characteristics, and advantages of pg_search. We examined how it enhances
pg_search: Modern Full-Text Search Inside PostgreSQL: Part 2 Read Post »
Performance Optimization And Replication in PostgreSQL
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: 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 »
Writing your First PostgreSQL Extension: A Guide to pg_query_filter
PostgreSQL is famous for its extensibility. While many people use it for its robust SQL engine, its true power lies
Writing your First PostgreSQL Extension: A Guide to pg_query_filter Read Post »
Oracle to PostgreSQL Migration: Testing and validation of CDC with Debezium & Apache Kafka
In Part 1, we built a complete open-source CDC pipeline using Debezium, Apache Kafka, and Oracle LogMiner to stream real-time
Beyond the Hype: PostgreSQL JSONB vs MongoDB BSON
In the early 2010s, the database world felt polarized. You either lived in the rigid, reliable world of Schema-on-Write (SQL)
Beyond the Hype: PostgreSQL JSONB vs MongoDB BSON Read Post »
Understanding PostgreSQL Row-Level Locking: A Practical Guide
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 »
From Chaos to Calendar: AI as an Ops Manager
From Chaos to Calendar: AI as an Ops Manager Most services startups don’t suffer from lack of effort. They suffer
From Chaos to Calendar: AI as an Ops Manager Read Post »
Understanding Database Performance Based on Query Behavior
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 »
Oracle to PostgreSQL Migration: CDC with Debezium & Apache Kafka
In today’s open-source ecosystem, organizations are increasingly adopting open-source technologies to reduce licensing costs, avoid vendor lock-in, and improve flexibility
Oracle to PostgreSQL Migration: CDC with Debezium & Apache Kafka 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
Understanding Repmgr Architecture: Fencing & VIP Management Challenges
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 »
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 »
The Hidden Value of Technical Account Managers in PostgreSQL
Technical Account Manager → The name itself creates curiosity with inclusion of words Technical + Management.Continuing with this curiosity let
The Hidden Value of Technical Account Managers in PostgreSQL Read Post »
Implementing Global Temporary Tables in PostgreSQL with pgtt
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 »
We Automated 40% of Our Operations — Not to Move Faster, but to Think Better
We Automated 40% of Our Operations — Not to Move Faster, but to Think Better Automation promises order—silence where there
We Automated 40% of Our Operations — Not to Move Faster, but to Think Better 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 »
PostgreSQL 18: Breaking the Conflict Deadlock in Logical Replication
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 »
The Evolving Role of a Solution Engineer in a Digital-First World
Friday, January 30th 2026 A remarkable day at WomenForData Summit 2026 and I had the opportunity to deliver a power
The Evolving Role of a Solution Engineer in a Digital-First World 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 »