Re: Autovacuum worker doesn't immediately exit on postmaster death
От
Alvaro Herrera
Тема
Re: Autovacuum worker doesn't immediately exit on postmaster death
Дата
Msg-id
20201029163227.GA20322@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-29, Stephen Frost wrote: > > It's hard to do better than that, because on most platforms there's > > no way to get a signal on parent-process death, so the only way to > > notice would be to poll the postmaster-death pipe constantly; which > > would be hugely expensive in comparison to the value. > > I agree that 'constantly' wouldn't be great, but with some periodicity > that's more frequent than 'not until a few hours later when we finally > finish vacuuming this relation' would be nice. At least with autovauum > we may be periodically sleeping anyway so it doesn't seem like polling > at that point would really be terrible, though it'd be nice to check > every once in a while even if we aren't sleeping. vacuum_delay_point seems an obvious candidate, as soon as we've determined that the sleep interval is > 0; since we're going to sleep, the cost of a syscall seems negligible. I'm not sure what to suggest for vacuums that don't have vacuum costing active, though.
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Alvaro Herrera
Дата: