Re: AW: [Extern] Re: autovacuum on pg_catalog tables

2021-06-04 Thread Laurenz Albe
On Fri, 2021-06-04 at 15:43 +, 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

Re: AW: [Extern] Re: autovacuum on pg_catalog tables

2021-06-04 Thread Tom Lane
"Zwettler Markus (OIZ)" writes: > I do not see any reason why this should not work or be at risk? I think the only problem you'd be likely to run into is that pg_dump/pg_upgrade won't propagate those settings for you. autovacuum doesn't really treat catalogs differently from user tables, AFAIR.