Tag: Amazon RDS

Miscellaneous

A Case Study of Tuning Autovacuum in Amazon RDS for PostgreSQL

In a PostgreSQL database, the autovacuum process performs multiple critical maintenance operations. In addition to freezing the transaction ID to prevent it from wraparound, autovacuum also removes dead tuples to recover space usage. For databases with a high volume of write operations, it is recommended that you tune autovacuum to run frequently. Doing this helps …

Miscellaneous

Best Practices for Upgrading Amazon RDS for MySQL and Amazon RDS for MariaDB

One key feature of Amazon RDS is that you can easily upgrade a database instance to a new minor or major version of your database engine. You can perform upgrades on demand by using the AWS Management Console or AWS CLI. You can decide to automatically upgrade to a new minor engine version when it …