Infra review of Autovacuum historical comments and decisions

The goal of this issue is to map all the info we have available for all the analysis and troubleshooting for the database autovacuum setup.

Acceptance criteria: