Re: Berserk Autovacuum (let's save next Mandrill)
От
Laurenz Albe
Тема
Re: Berserk Autovacuum (let's save next Mandrill)
Дата
Msg-id
9865a51c95bc8dee27a3e0ced92b28233add63a6.camel@cybertec.at
Ответ на
Re: Berserk Autovacuum (let's save next Mandrill) (Andres Freund)
Список
Дерево обсуждения
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 по дате отправления