Site–Infra is creating documentation regarding Autovacuum in RDS for PostgreSQL. This document aims to provide guides on how to check your database Autovacuum condition and what actions do you need to do for your database related to Autovacuum.
Why do we need to care about Autovacuum?
The main reason is to reduce risk and avoid transaction ID wraparound for our PostgreSQL database.
PostgreSQL has a safety mechanism to avoid transaction ID by doing force vacuum. When this happens the PostgreSQL database will be on read-only mode.
You can go to the following link to read the documentation :
https://bit.ly/2QPGF6o
Feel free to put your comment, suggestion, and correction on the document. As usual, you can also reach us out on #site-infra-channel