Re: autovacuum doesnt run on the pg_toast_id table

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: autovacuum doesnt run on the pg_toast_id table
Date: 2019-01-17 17:52:41
Message-ID: 201901171752.2cdiwqezrwjk@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 2019-Jan-17, Mariel Cherkassky wrote:

> I tried to set the same threshold for the toasted table but got an error
> that it is a catalog table and therefore permission is denied.
> 2019-01-17 12:04:15 EST db116109 ERROR: permission denied:
> "pg_toast_13388392" is a system catalog
> 2019-01-17 12:04:15 EST db116109 STATEMENT: alter table
> pg_toast.pg_toast_13388392 set (autovacuum_vacuum_scale_factor=0.05);

The right way to do this is
alter table main_table set (toast.autovacuum_vacuum_scale_factor = 0.05);

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2019-01-17 17:58:17 Re: autovacuum doesnt run on the pg_toast_id table
Previous Message Justin Pryzby 2019-01-17 17:46:51 Re: autovacuum doesnt run on the pg_toast_id table