"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
);
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
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
"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.
Why not change the defaults? How many tables would hit this new threshold
and you would NOT want autovacuum to process them?
>
: 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
2021 at 20:10, Zwettler Markus (OIZ) <
markus.zwett...@zuerich.ch> wrote:
> I would like to start a more aggressive autovacuum on pg_catalog tables
> like pg_largeobject.
>
>
>
> So I tried as a superuser:
>
>
>
> # alter table pg_catalog.pg_largeobject_metadata
I would like to start a more aggressive autovacuum on pg_catalog tables like
pg_largeobject.
So I tried as a superuser:
# alter table pg_catalog.pg_largeobject_metadata set
(autovacuum_vacuum_scale_factor = 0, autovacuum_vacuum_threshold = 5000);
ERROR: permission denied
