autovacuum on pg_catalog tables

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: autovacuum on pg_catalog tables
Date: 2021-06-04 14:40:38
Message-ID: b3fbaca128484f059c9c78b8a3c1ad88@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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: "pg_largeobject_metadata" is a system catalog

(How) Is it possible to change such table attributes on pg_catalog tables?

Thanks, Markus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-06-04 14:44:59 Re: EXCLUDE USING and tstzrange
Previous Message Laura Smith 2021-06-04 14:32:53 EXCLUDE USING and tstzrange