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 »
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 »
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 »
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 »
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 ConnectionsNovember marks the start of Networking November, a month where we celebrate the
Building Bonds Beyond the Event: Celebrating Community Connections 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 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 D-Day: Wrap Up with Our Top picks, Community shout-outs & Postgres gratitude. What a Month!Over the last 31
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 »
Welcome back to the Day29 of the PG18Hacktober !! pg_unicode_fast is a new built-in collation introduced in PostgreSQL 18, available exclusively
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 »
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 »
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 »
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 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 »
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 »
Welcome to a brand-new segment of PG18Hacktober — Client Applications, where we explore the exciting enhancements and hidden gems that
PG18 Hacktober: 31 Days of New Features : Supercharging psql with Pipeline Query Support Read Post »
In today’s post of the PG18 Hacktober segment!, we’re going to discuss the postgres_fdw SCRAM authentication pass throughout. Introduction :
In today’s continuation of the PG18 Hacktober series, we’re diving deeper into PostgreSQL 18’s enhanced LIKE clause for creating foreign
In today’s post of the PG18 Hacktober segment!, we’re going to discuss the LIKE operator that was introduced to simplify
