Re: Autovacuum worker doesn't immediately exit on postmaster death

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Autovacuum worker doesn't immediately exit on postmaster death
Дата
Msg-id
20201029163507.GA20933@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
Autovacuum worker doesn't immediately exit on postmaster death Alexander Kukushkin <cyberdemn@gmail.com>
Re: Autovacuum worker doesn't immediately exit on postmaster death Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Autovacuum worker doesn't immediately exit on postmaster death Victor Yegorov <vyegorov@gmail.com>
Re: Autovacuum worker doesn't immediately exit on postmaster death Tom Lane <tgl@sss.pgh.pa.us>
Re: Autovacuum worker doesn't immediately exit on postmaster death Stephen Frost <sfrost@snowman.net>
Re: Autovacuum worker doesn't immediately exit on postmaster death Tom Lane <tgl@sss.pgh.pa.us>
Re: Autovacuum worker doesn't immediately exit on postmaster death Andres Freund <andres@anarazel.de>
Re: Autovacuum worker doesn't immediately exit on postmaster death Stephen Frost <sfrost@snowman.net>
Re: Autovacuum worker doesn't immediately exit on postmaster death Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Autovacuum worker doesn't immediately exit on postmaster death Tom Lane <tgl@sss.pgh.pa.us>
Re: Autovacuum worker doesn't immediately exit on postmaster death Stephen Frost <sfrost@snowman.net>
Re: Autovacuum worker doesn't immediately exit on postmaster death Stephen Frost <sfrost@snowman.net>
Re: Autovacuum worker doesn't immediately exit on postmaster death Robert Haas <robertmhaas@gmail.com>
Re: Autovacuum worker doesn't immediately exit on postmaster death Thomas Munro <thomas.munro@gmail.com>
Re: Autovacuum worker doesn't immediately exit on postmaster death Alvaro Herrera <alvherre@alvh.no-ip.org>
On 2020-Oct-28, Alexander Kukushkin wrote:

> Hello,
> 
> I know, nobody in their mind should do that, but, if the postmaster
> process is killed with SIGKILL signal, most backend processes
> correctly notice the fact of the postmaster process absence and exit.
> There is one exception though, when there are autovacuum worker
> processes they are continuing to run until eventually finish and exit.

So, if you have a manual vacuum running on the table (with
vacuum_cost_delay=0) and kill -KILL the postmaster, that one also
lingers arbitrarily long afterwards?

(I suppose the problem is not as obvious just because the vacuum
wouldn't run as long, because of no vacuum cost delay; but it'd still be
a problem if you made the table bigger.)


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