What’s New in PostgreSQL 17: Essential Updates for DBAs and Developers
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…
Read article
Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support
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…
Hypothetical Indexes in PostgreSQL: Enhancing Performance Without the Overhead
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…
A Glimpse into the Future: Series of What’s New in PostgreSQL16 ?
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…
Optimizing Initial Sync for Large Databases in RDS PostgreSQL using pg_dump in Logical Replication
PostgreSQL provides a built-in logical replication system based on the publish/subscribe model, where a publisher publishes data changes to a publication, and a subscriber subscribes…
Essential Queries for PostgreSQL Health Assessment
In this post, we’ll look at a few crucial queries that are helpful for exploring into PostgreSQL problems and evaluating the health of an existing…