On Fri, 2021-06-04 at 15:43 +0000, Zwettler Markus (OIZ) wrote:
> I have a lot of LO manipulation and want a more aggressive autovacuum on some pg_catalog tables therefore.
>
> I do not see any reason why this should not work or be at risk?
It is not a risk per se. The biggest problem is that any such catalog
modifications would be lost after an upgrade.
I would change the parameters in "postgresql.conf" and then override the
settings for user table to be less aggressive where necessary.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com