Customers Speak: Aiven at PGConf India
On March 12th & 13th, 2026, I had the privilege of staffing the Aiven booth at PGConf India in Bengaluru, […]
Customers Speak: Aiven at PGConf India Read Post »
Built to Deliver: OpenSource DB & HexaCluster at PGConf India 2026
Some partnerships look good on paper. This one looks good in production. OpenSource DB has partnered with HexaCluster — one
Built to Deliver: OpenSource DB & HexaCluster at PGConf India 2026 Read Post »
All In on Open Source: OpenSource DB & Percona at PGConf India 2026
OpenSource DB and Percona, the global leader in open-source database software, support, and services, and together we’ll be at PGConf
All In on Open Source: OpenSource DB & Percona at PGConf India 2026 Read Post »
From Manual Tuning to AI Intelligence: How DBtune is Revolutionizing PostgreSQL Performance Across the Cloud
In the world of database administration, performance tuning has long been considered as more room to improve. For decades, DBAs
Stronger Together:OpenSource DB & Aiven Heading to PGConf India 2026
We have big news. OpenSource DB partned with Aiven, the leading open-source data platform in the cloud, and together we’ll
Stronger Together:OpenSource DB & Aiven Heading to PGConf India 2026 Read Post »
Who Owns Connection Pooling? The App Team vs. DB Team Debate
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 »
Terabyte-Scale PostgreSQL Logical Replication: The Challenges nobody warns us about
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 »
The Ultimate PostgreSQL Power-User Manual: Why Postgres is a toolbox, Not Just a Database
In the high-stakes world of High Availability (HA), meticulous performance tuning, and mission-critical production systems, veteran Database Administrators and System
Understanding Dynamic Shared Memory (DSM) in PostgreSQL
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 »
BM25 in PostgreSQL: Modern Relevance Ranking and the Growing Search Ecosystem
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 »
How Patroni Brings High Availability to PostgreSQL
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 »
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 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