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

2021-06-07 Thread Tom Lane
"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

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

2021-06-07 Thread Zwettler Markus (OIZ)
); ERROR: AccessExclusiveLock required to add toast table. Time: 1.601 ms Any idea? Thanks, Markus Von: Zwettler Markus (OIZ) Gesendet: Freitag, 4. Juni 2021 17:44 An: Vijaykumar Jain Cc: pgsql-general@lists.postgresql.org Betreff: AW: [Extern] Re: autovacuum on pg_catalog tables Thanks

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.

Re: [Extern] Re: autovacuum on pg_catalog tables

2021-06-04 Thread Michael Lewis
Why not change the defaults? How many tables would hit this new threshold and you would NOT want autovacuum to process them? >

AW: [Extern] Re: autovacuum on pg_catalog tables

2021-06-04 Thread Zwettler Markus (OIZ)
: pgsql-general@lists.postgresql.org Betreff: [Extern] Re: autovacuum on pg_catalog tables ok, what i am sharing, DO NOT DO IT. it is just to answer why it is not working :) PostgreSQL: Documentation: 13: 19.17. Developer Options<https://www.postgresql.org/docs/current/runtime-config-developer.h

Re: autovacuum on pg_catalog tables

2021-06-04 Thread Vijaykumar Jain
ok, what i am sharing, *DO NOT DO IT.* it is just to answer why it is not working :) PostgreSQL: Documentation: 13: 19.17. Developer Options postgres=# alter table pg_catalog.pg_largeobject_metadata set (AUTOVACUUM_VACUUM_CO