Recently, we encountered an issue where catalog queries executed by the drivers during session creation were taking significantly longer than expected. These queries, managed by…
Introduction With the release of PostgreSQL 17, a game-changing feature has arrived: incremental backups. In prior versions, such as PostgreSQL 16 and earlier, users could…
The PostgreSQL Global Community team released the PostgreSQL 17 RC1. We’re excited to share a glimpse of some of the key features coming in PostgreSQL…
Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support Recently we did an upgrade of the legacy PostgreSQL 9.1 database of 1…
Introduction Indexes are essential for speeding up query execution in PostgreSQL, but determining whether an index will be utilized in the execution plan can be…
On September 14, 2023, the PostgreSQL Global Development Group introduced PostgreSQL 16, marking the latest release of the renowned open-source database. This version brings significant…
