From: Tom Lane <tgl@sss.pgh.pa.us>
To: Noah Misch <noah@leadboat.com>
Cc: Gustavsson Mikael <mikael.gustavsson@smhi.se>
Cc: pgsql-bugs@lists.postgresql.org, Svensson Peter <peter.svensson@smhi.se>
Cc: Almen Anders <anders.almen@smhi.se>
Subject: Re: SV: Problem with pg_notify / listen
Date: Sat, 28 Nov 2020 14:15:11 -0500
Message-ID: <901794.1606590911@sss.pgh.pa.us> (raw)
In-Reply-To: <20201128041001.GB556656@rfd.leadboat.com>
References: <1b8561412e8a4f038d7a491c8b922788@smhi.se>
<704331.1606490493@sss.pgh.pa.us>
<6c10dcdd2eb64bbab4814e4f2abd5ab4@smhi.se>
<7a0df07fb3f94dfe80839942ab5993c7@smhi.se>
<716909.1606498665@sss.pgh.pa.us>
<730247.1606515208@sss.pgh.pa.us>
<20201128035906.GA556656@rfd.leadboat.com>
<744927.1606536220@sss.pgh.pa.us>
<20201128041001.GB556656@rfd.leadboat.com>
Noah Misch <noah@leadboat.com> writes:
> On Fri, Nov 27, 2020 at 11:03:40PM -0500, Tom Lane wrote:
>> Hmm, it's not very clear what "stop" means here. What do you think of
>> QUEUE_OLDEST_PAGE?
> QUEUE_OLDEST_PAGE is fine. I like it a little less than QUEUE_STOP_PAGE,
> because oldestClogXid is a logical tail, and QUEUE_OLDEST_PAGE would be a
> physical tail.
I went with QUEUE_STOP_PAGE.
In further testing, I noted that the patch as I had it re-introduced the
symptom that 8b7ae5a82 fixed, that running "make installcheck" twice
in a row causes the async-notify isolation test to fail. That's because
I'd changed asyncQueueUsage() to measure the distance back to the physical
tail, which isn't stable because we only truncate after crossing an
SLRU segment boundary. So I reverted it to measuring the distance to
QUEUE_TAIL. You could argue either way about which definition is more
useful to end users, perhaps; but in practice the difference should
usually be too small to matter, for everyone except regression tests
that are looking for distance exactly zero.
Anyhow, pushed with that fix.
Mikael, it appears that you have three options: revert to 11.9 until 11.11
is out, restart your server every time it approaches notify-queue-full, or
apply this patch:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=40f2fbe71ad615a2bcaaf5b840ccb9329e4378...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, noah@leadboat.com, mikael.gustavsson@smhi.se, peter.svensson@smhi.se, anders.almen@smhi.se
Subject: Re: SV: Problem with pg_notify / listen
In-Reply-To: <901794.1606590911@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox