autovacuum on pg_catalog tables - Mailing list pgsql-general

From Zwettler Markus (OIZ)
Subject autovacuum on pg_catalog tables
Date
Msg-id b3fbaca128484f059c9c78b8a3c1ad88@zuerich.ch
Whole thread Raw
Responses Re: autovacuum on pg_catalog tables  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List 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

 

 

pgsql-general by date:

Previous
From: Laura Smith
Date:
Subject: EXCLUDE USING and tstzrange
Next
From: Adrian Klaver
Date:
Subject: Re: EXCLUDE USING and tstzrange