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 »
Every startup begins with a spark, an idea, a Founder’s vision, and a small, scrappy team ready to do whatever
From Playbook to Powerhouse: Scaling up with strategy Read Post »
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 »
This is the best TL; DR I could up with: – Financial sustainability: Unit economics and capital efficiency– Organizational sustainability:
Sustainability Strategy — Endurance over explosions Read Post »
When something goes wrong in PostgreSQL, most people first look at logs, queries, or monitoring dashboards. But there’s another very
Understanding PostgreSQL system catalogs for Troubleshooting Read Post »
At OpenSource DB, we believe startups don’t win by going solo — they scale by building strong alliances. Most people
Synergy Strategy: Winning Together as a Startup Read Post »
Introduction: For developers, DevOps engineers, QA analysts, and product managers alike, the moment an application goes live in production is
Go-Live to Production: Best Practices and Testing in a Pre Prod environment: Part-1 Read Post »
Simplify strategy: Less but betterMost teams believe more = better.More goals. More projects. More metrics. Reality: That ambition often backfires.
Simplify Strategy: Less but Better Read Post »
Introduction: In PostgreSQL, Asynchronous parameters are essential for optimizing how the database performs background operations, manages disk I/O, and executes
Understanding PostgreSQL Parameters: Asynchronous parameters Read Post »
Introduction In the previous blog, we explored the fundamentals of logical decoding and logical replication. Now, let’s go one step
Week 4 – In fast-moving environments, speed alone isn’t enough—learning quickly and iterating effectively is what separates high-performing teams from
Building Feedback Loops Across Teams for Faster Learning and Iteration Read Post »
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 »
