How to fine tune autovacuum settings for the PostgreSQL database

[zacktzeng]

Hello, is there a good guideline on configuring autovacuum settings? I know databases for different companies can be very different, but is there documentation for configuring different autovacuum components based on database performance metrics?

Thanks!

[alain.kermis]

Hi @zacktzeng,

Routine vacuuming is a rather complex topic, as described in the official docs. However, there are some guidelines on the Percona website here which describe tuning auto vacuum, but keep in mind it is from 2018.

However, I would also refer to our official documentation for more details.

Regards
Alain