pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
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
Date: Thu, 17 Jan 2019 16:09:01 -0300
Message-ID: <201901171909.eb4o7z7hikas@alvherre.pgsql> (raw)
In-Reply-To: <CA+t6e1n0TrgvHdB6cPTC5fceom2RfwE9=e1TKPmwZiCBJ0iTcw@mail.gmail.com>
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
view thread (8+ messages) latest in thread
Message-ID: <201901171909.eb4o7z7hikas@alvherre.pgsql> Permalink: ../201901171909.eb4o7z7hikas@alvherre.pgsql/ Also on: postgresql.org/message-id/201901171909.eb4o7z7hikas@alvherre.pgsql ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-performance@postgresql.org Cc: alvherre@2ndquadrant.com, mariel.cherkassky@gmail.com, pgsql-performance@lists.postgresql.org Subject: Re: autovacuum doesnt run on the pg_toast_id table In-Reply-To: <201901171909.eb4o7z7hikas@alvherre.pgsql> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox