Re: Berserk Autovacuum (let's save next Mandrill)

Поиск
Список
Период
Сортировка
Искать
От
Laurenz Albe
Тема
Re: Berserk Autovacuum (let's save next Mandrill)
Дата
Msg-id
9865a51c95bc8dee27a3e0ced92b28233add63a6.camel@cybertec.at
Ответ на
Список
Дерево обсуждения
Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Robert Haas <robertmhaas@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Amit Langote <amitlangote09@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <david.rowley@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Michael Banck <mbanck@gmx.net>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <sawada.mshk@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Amit Kapila <amit.kapila16@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <sawada.mshk@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Amit Kapila <amit.kapila16@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) James Coleman <jtc331@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) James Coleman <jtc331@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) James Coleman <jtc331@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) Amit Kapila <amit.kapila16@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) Dean Rasheed <dean.a.rasheed@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tom Lane <tgl@sss.pgh.pa.us>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Andres Freund <andres@anarazel.de>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <dgrowleyml@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Justin Pryzby <pryzby@telsasoft.com>
Re: Berserk Autovacuum (let's save next Mandrill) Laurenz Albe <laurenz.albe@cybertec.at>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Chris Travers <chris.travers@adjust.com>
Re: Berserk Autovacuum (let's save next Mandrill) Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <sawada.mshk@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <sawada.mshk@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) David Rowley <david.rowley@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <sawada.mshk@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Chris Travers <chris.travers@adjust.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Masahiko Sawada <sawada.mshk@gmail.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: Berserk Autovacuum (let's save next Mandrill) Vik Fearing <vik.fearing@2ndquadrant.com>
Re: Berserk Autovacuum (let's save next Mandrill) Darafei "Komяpa" Praliaskouski <me@komzpa.net>
On Tue, 2020-03-17 at 17:26 -0700, Andres Freund wrote:
> On 2020-03-17 01:14:02 +0100, Laurenz Albe wrote:
> > lazy_check_needs_freeze() is only called for an aggressive vacuum, which
> > this isn't.
> 
> Hm? I mean some of these will be aggressive vacuums, because it's older
> than vacuum_freeze_table_age? And the lower age limit would make that
> potentially more painful, no?

You are right.  I thought of autovacuum_freeze_max_age, but not of
vacuum_freeze_table_age.

Autovacuum configuration is so woefully complicated that it makes me
feel bad to propose two more parameters :^(

Yours,
Laurenz Albe



В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Thomas Munro
Дата:
FAQ