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 обсуждение исходный текст |
Ответ на | Re: Autovacuum worker doesn't immediately exit on postmaster death (Stephen Frost <sfrost@snowman.net>) |
Список | pgsql-hackers |
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 по дате отправления: