AWS Database Blog
Author: Naga Appani
Prevent transaction ID wraparound by using postgres_get_av_diag() for monitoring autovacuum
In this post, we introduce postgres_get_av_diag(), a new function available in RDS for PostgreSQL and Aurora PostgreSQL to monitor aggressive autovacuum blockers.
Introducing Optimized Reads for Amazon RDS for PostgreSQL
In March 2022, we introduced a new Multi-AZ deployment option for Amazon Relational Database Service (Amazon RDS) for PostgreSQL, called Multi-AZ DB clusters. This deployment option increases read capacity with two readable standby instances, and improves write transaction latency and failover times. The optimization of transaction latency uses local storage on purpose-built Amazon Elastic Compute […]
Tune sorting operations in PostgreSQL with work_mem
Sorting is one of the most fundamental operations in databases, and optimizing this process is vital to the performance of applications. Sorting involves arranging records in a database table into some meaningful order to make it easier to understand, analyze, and visualize the data. For example, you might want to sort orders by their delivery […]