"Zwettler Markus (OIZ)" writes:
> I tried this on postgres 9.6:
> postgresql.conf -> allow_system_table_mods=on + pg_ctl restart
> # alter table pg_catalog.pg_shdepend set (autovacuum_vacuum_scale_factor = 0,
> autovacuum_vacuum_threshold = 1000);
> ERROR: shared tables cannot be toasted af
I have some hundred (user) tables where only a small subset of them requires a
more aggressive autovacuum.
Setting table level parameters on this small subset seems more straightforward
to me.
Loosing this setting on pg_dump / pg_upgrade would be ok for me. Doesn't happen
that often.
I tried
