In Part 1 we covered logging, WAL and I/O: log_lock_waits on by default, per-process log levels, wal_fpi_bytes and the new
Every PostgreSQL release quietly improves how much you can see about what your database is doing. PostgreSQL 19 is no
For years, pg_buffercache has been the DBA’s window into shared_buffers: which relations are cached, how hot they are, and which
Marking Buffers Dirty: Exploring New pg_buffercache Capabilities Read Post »
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, 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 »
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 »
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 »
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 »
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 »
Welcome to Day 25 of the PG18 Hacktober PostgreSQL continues to evolve with powerful extensions that help developers and DBAs
PG18 Hacktober: 31 Days of New Features : pg_logicalinspect Logical Replication Insights Read Post »
Welcome to the 14th blog post in the “Logical replication” segment of PG18 Hacktober! PostgreSQL 18 introduced significant enhancements in
PG18 Hacktober: 31 Days of New Features : Logical Replication – Write Conflict Logging Read Post »
Welcome to the 12th blog post in the “logical replication” segment of PG18 Hacktober! In the previous blog, we explored how
Welcome to the 11th blog post in the “logical replication” segment of PG18 Hacktober! Stored Generated Columns are now fully supported
Modern data systems thrive on real-time change streams. Whether it’s auditing user actions, replicating changes across databases, or feeding events
Streaming PostgreSQL changes as JSON with wal2json Read Post »
Introduction In the previous blog, we explored the fundamentals of logical decoding and logical replication. Now, let’s go one step
Introduction PostgreSQL, a powerful open-source relational database, offers multiple replication strategies to support high availability, scalability, and integration. Among them,
Logical Decoding and Logical Replication in PostgreSQL Read Post »
Let’s learn how to compress, clean up, and retain PostgreSQL WAL files efficiently for PITR, replication, and backups. PostgreSQL’s Write-Ahead
Best Practices for WAL Archiving: Compression, Cleanup & Retention Read Post »
When it comes to managing PostgreSQL backups in production, pgBackRest has consistently stood out as one of the most powerful,
Evolving PostgreSQL Backups: My experience with automating backups Read Post »
Last Friday, I had the privilege of attending the Hyderabad PostgreSQL User Group Meetup, a fantastic gathering of PostgreSQL enthusiasts
