Troubleshooting IO Issues in Aurora PostgreSQL: Understanding StorageNetworkThroughput Limits

PostgresqlLeave a comment

Aurora PostgreSQL is a robust, cloud-native database solution known for its scalability, high availability, and managed services. One of its standout features is the virtually unlimited IOPS (Input/Output Operations Per Second) and throughput at the storage layer. However, while the storage layer itself may not impose limits, the instances running Aurora PostgreSQL have specific thresholds…

Stop Catalog Bloat: Boost PostgreSQL Performance by Replacing Temporary Tables

PostgresqlLeave a comment

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 PHP drivers, were impacted by a performance bottleneck. Due to this user session creations are taking more time. Upon investigation, I discovered that the pg_attribute and pg_class system catalog tables…