Engineering PostgreSQL for High Availability on Aiven: Replication, Failover, and Performance
This post dives into what happens under the hood of Aiven PostgreSQL, including synchronous replication design, automated leader election, fencing […]
Saying “No” Helps you grow
Decision December: Choosing What Truly Moves the Needle Week 1 — Saying “No” is a Growth Strategy Theme: Ruthless prioritization
Saying “No” Helps you grow Read Post »
Enterprise-Grade PostgreSQL, Kafka & Beyond: Simplified with Aiven + OpenSource DB
Enterprises are rapidly moving away from monolithic proprietary databases toward distributed and open-source data platforms — PostgreSQL, Kafka, OpenSearch, ClickHouse,
Enterprise-Grade PostgreSQL, Kafka & Beyond: Simplified with Aiven + OpenSource DB Read Post »
Spotlight on People & Impact
The People Who Drive Our Postgres Communities Forward As we celebrate Thanksgiving weekend, it’s the perfect time to express gratitude
Spotlight on People & Impact Read Post »
November ’25 PostgreSQL Minor Release: What You Need to Know
On November 13th, 2025, the PostgreSQL Global Development Group released updates across all supported versions: 18.1, 17.7, 16.11, 15.15, 14.20,
November ’25 PostgreSQL Minor Release: What You Need to Know Read Post »
Partnerships that Empower
Strengthening Our Ecosystem Through Meaningful Collaborations In today’s fast-moving technology landscape, no organization grows in isolation. True progress happens when
Partnerships that Empower Read Post »
Understanding Subqueries in PostgreSQL- Part 1
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 »
Collaboration in Action
How Teamwork and Partnerships drive the PostgreSQL community forwardAt OpenSource DB (OSDB), collaboration is not just a guiding value, it’s
Collaboration in Action Read Post »
Resolving Replica Identity Issues After Dropping Logical Replication
Recently, one of our clients encountered a perplexing issue with their PostgreSQL database. They had been using logical replication and
Resolving Replica Identity Issues After Dropping Logical Replication Read Post »
Building Bonds Beyond the Event: Celebrating Community Connections
Building Bonds Beyond the Event: Celebrating Community ConnectionsNovember marks the start of Networking November, a month where we celebrate the
Building Bonds Beyond the Event: Celebrating Community Connections Read Post »
Postgres HA Architecture: Eliminating SPoF with Keepalived
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 »
Cultural Optimization: Building a continuous improvement mindset
At OpenSource DB, we believe optimization isn’t just about databases, queries, or infrastructure, it’s about People and Culture.A high-performing organization
Cultural Optimization: Building a continuous improvement mindset Read Post »
PG18 Hacktober: 31 Days of New Features : Wrap Up with Our Top picks,Community shout-outs & Postgres gratitude
PG18 Hacktober D-Day: Wrap Up with Our Top picks, Community shout-outs & Postgres gratitude. What a Month!Over the last 31
PG18 Hacktober: 31 Days of New Features : Catalog Views Got Smarter
Welcome to the Day30 of PG18Hacktober !! PostgreSQL 18 brings significant improvements to its system catalogs and statistics views, expanding
PG18 Hacktober: 31 Days of New Features : Catalog Views Got Smarter Read Post »
PG18 Hacktober: 31 Days of New Features : Internationalization: pg_unicode_fast Collation
Welcome back to the Day29 of the PG18Hacktober !! pg_unicode_fast is a new built-in collation introduced in PostgreSQL 18, available exclusively
PG18 Hacktober: 31 Days of New Features : Internationalization LIKE comparisons
In PostgreSQL 18, the LIKE operator becomes more powerful and more compliant with the SQL standard, it now supports use
PG18 Hacktober: 31 Days of New Features : Internationalization LIKE comparisons Read Post »
PG18 Hacktober: 31 Days of New Features : casefold() function
Welcome to the 27th blog post of PG18 Hacktober! Among the many new features, one quiet and small feature is making
PG18 Hacktober: 31 Days of New Features : casefold() function Read Post »
PG18 Hacktober: 31 Days of New Features : pg_overexplain – See the Real Plans
Welcome to Day 26 of the PG18 Hacktober series! Have you had this discussion with Devs? I wrote a clean
PG18 Hacktober: 31 Days of New Features : pg_overexplain – See the Real Plans Read Post »
PG18 Hacktober: 31 Days of New Features : pg_logicalinspect Logical Replication Insights
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 »
PG18 Hacktober: 31 Days of New Features : Named Prepared Statements
Welcome to the 24th blog post of PG18 Hacktober! The release of PostgreSQL 18 introduced a valuable enhancement for developers who
PG18 Hacktober: 31 Days of New Features : Named Prepared Statements Read Post »
Financial efficiency and Smart spending
Getting more value out of every rupee, the open way.Smart spending in 2025, balancing growth, innovation, and financial discipline. In
Financial efficiency and Smart spending Read Post »