PG18 Hacktober: 31 Days of New Features : Planning ahead: PG18 retains planner stats during Upgrades
Welcome to the Day2 of the PG18 Hacktober!!Upgrading PostgreSQL major versions has always been a balancing act: you get shiny […]
PG18 Hacktober: 31 Days of New Features : Unveiling pg_upgrade –swap option
On September 25, 2025, PostgreSQL—the world’s most advanced open-source database—hit a new milestone. Version 18 is here, and it’s packed
PG18 Hacktober: 31 Days of New Features : Unveiling pg_upgrade –swap option Read Post »
From Playbook to Powerhouse: Scaling up with strategy
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 »
Streaming PostgreSQL changes as JSON with wal2json
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 »
Sustainability Strategy — Endurance over explosions
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 »
Understanding PostgreSQL system catalogs for Troubleshooting
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 »
Synergy Strategy: Winning Together as a Startup
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 »
Go-Live to Production: Best Practices and Testing in a Pre Prod environment: Part-1
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 Better
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 »
Understanding PostgreSQL Parameters: Asynchronous parameters
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 »
Advanced Logical Replication in PostgreSQL: Conflict Handling, Tuning & Real-World Patterns
Introduction In the previous blog, we explored the fundamentals of logical decoding and logical replication. Now, let’s go one step
Building Feedback Loops Across Teams for Faster Learning and Iteration
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 »
Logical Decoding and Logical Replication in PostgreSQL
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 »
Setting Up Repeatable Processes: The Freedom to Focus on What Matters
Week 3 – Architecting August blogpost – As we celebrate Independence Day, we often think about freedom in terms of
Setting Up Repeatable Processes: The Freedom to Focus on What Matters Read Post »
Best Practices for WAL Archiving: Compression, Cleanup & Retention
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 »
The Founder’s Dilemma: Familiar vs Fit-for-Future
Choosing the Right Tech Stack: Balancing the Now vs the NextWhen you’re building a product — especially in a startup
The Founder’s Dilemma: Familiar vs Fit-for-Future Read Post »
PostgreSQL Index Testing with HypoPG extension
Introduction: One of our customers were experiencing high CPU utilization during specific operations. We conducted close monitoring of the system
PostgreSQL Index Testing with HypoPG extension Read Post »
Designing Startup Systems That Scale: Hiring, Tech, Culture, Ops
Architecting August – Week 1 In the zero-to-one phase, most startup decisions are reactive.You hire fast. You build fast. You
Designing Startup Systems That Scale: Hiring, Tech, Culture, Ops Read Post »
pgroll in Action: Client-Side Evaluation of Zero-Downtime Schema Migrations
Introduction Schema migrations in PostgreSQL are notoriously hard to get right, especially when your systems require zero downtime. Anyone who’s
pgroll in Action: Client-Side Evaluation of Zero-Downtime Schema Migrations Read Post »
Sell Before You Scale: GTM for Founders Who Hate Selling
🧩Week 4 Theme: Sales and GTM Jumpstarts for Early-Stage Startups“Jump-start July” Series – Insights and tactics to accelerate early wins
Sell Before You Scale: GTM for Founders Who Hate Selling Read Post »
Upgrading PostgreSQL 12.15 to 14.18 in RHEL 8 Air-Gapped Systems: A Comprehensive Guide – Part-2
This is the part 2, continuation of the blog Upgrading PostgreSQL 12.15 to 14.18 in RHEL 8 Air-Gapped Systems: A