Date: Thu, 17 Jan 2019 16:09:01 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: autovacuum doesnt run on the pg_toast_id table
Message-ID: <201901171909.eb4o7z7hikas@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CA+t6e1n0TrgvHdB6cPTC5fceom2RfwE9=e1TKPmwZiCBJ0iTcw@mail.gmail.com>
User-Agent: NeoMutt/20180716-1013-2c1e88
Precedence: bulk

On 2019-Jan-17, Mariel Cherkassky wrote:

> I did it for the original table. But I see in the logs that the autovacuun
> on the toasted table isn't synced with the autovacuun of the original
> table. Therefore I thought that it worth to set it also for the toasted
> table. Can you explain why in the logs I see more vacuums of the original
> table then the toasted table ? Should they vacuumed together ?

No, they are processed separately, according to the formula explained in
the documentation.

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