From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Cc: Michael Banck <mbanck@gmx.net>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Berserk Autovacuum (let's save next Mandrill)
Date: Wed, 10 Apr 2019 11:13:06 -0400
Message-ID: <20190410151306.GA26795@alvherre.pgsql> (raw)
In-Reply-To: <CAC8Q8tJVO+2hZMrLyv=AaHKA45S8dcWC7kARUX6xU2qJSeoLqQ@mail.gmail.com>
On 2019-Mar-31, Darafei "Komяpa" Praliaskouski wrote:
> Alternative point of "if your database is super large and actively written,
> you may want to set autovacuum_freeze_max_age to even smaller values so
> that autovacuum load is more evenly spread over time" may be needed.
I don't think it's helpful to force emergency vacuuming more frequently;
quite the contrary, it's likely to cause even more issues. We should
tweak autovacuum to perform freezing more preemtively instead.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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-hackers@postgresql.org
Cc: alvherre@2ndquadrant.com, me@komzpa.net, mbanck@gmx.net, david.rowley@2ndquadrant.com, pgsql-hackers@lists.postgresql.org
Subject: Re: Berserk Autovacuum (let's save next Mandrill)
In-Reply-To: <20190410151306.GA26795@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