Learn how to improve Amazon Aurora PostgreSQL Performance by identifying StorageNetworkThroughput bottlenecks using Amazon CloudWatch. This real-world case study explains instance throughput limits, query optimization, workload analysis, and best practices for eliminating I/O bottlenecks in Aurora PostgreSQL.
PostgreSQL Catalog Bloat can significantly impact database performance when temporary tables are created and dropped frequently. This case study explains how excessive temporary table usage caused pg_attribute and pg_class to grow dramatically, slowed catalog queries and session creation, and how replacing temporary tables with reusable unlogged tables helped resolve the issue.
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 only perform full backups. This approach, while reliable, had its drawbacks—particularly the time it took to complete these backups and the storage they required. Previously, users relied on WAL (Write-Ahead…
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 17. For a deeper dive and thorough testing guidance, stay tuned as we’ll be releasing a series of blogs covering the top features in PostgreSQL 17 in more detail. Keep…
