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…
Read article
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…
IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL
IDENTIFY A ROLE HAS EXECUTE PERMISSION ON FUNCTION IN POSTGRESQL To identify a role has execute permission on function, PostgreSQL has a catalog function(has_function_privilege) which makes…