Re: Suppressing useless wakeups in walreceiver

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Suppressing useless wakeups in walreceiver
Дата
Msg-id CA+hUKGKw=+=TZ7xzVRQTNfDy5N_uwW_qWhOHDPHyiAkTQAYUug@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Suppressing useless wakeups in walreceiver  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: Suppressing useless wakeups in walreceiver  (Nathan Bossart <nathandbossart@gmail.com>)
Список pgsql-hackers
On Mon, Nov 14, 2022 at 1:05 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
> Yeah, I'm able to sort-of reproduce the problem by sending fewer replies,
> but it's not clear to me why that's the problem.  AFAICT all of the code
> paths that write/flush are careful to send a reply shortly afterward, which
> should keep writePtr/flushPtr updated.

Ahh, I think I might have it.  In the old coding, sendTime starts out
as 0, which I think caused it to send its first reply message after
the first 100ms sleep, and only after that fall into a cadence of
wal_receiver_status_interval (10s) while idle.  Our new coding won't
send its first reply until start time + wal_receiver_status_interval.
If I have that right, think we can get back to the previous behaviour
by explicitly setting the first message time, like:

@@ -433,6 +433,9 @@ WalReceiverMain(void)
            for (int i = 0; i < NUM_WALRCV_WAKEUPS; ++i)
                WalRcvComputeNextWakeup(i, now);

+           /* XXX start with a reply after 100ms */
+           wakeup[WALRCV_WAKEUP_REPLY] = now + 100000;
+
            /* Loop until end-of-streaming or error */

Obviously that's bogus and racy (it races with wait_for_catchup, and
it's slow, actually both sides are not great and really should be
event-driven, in later work)...



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Bitmapsets as Nodes
Следующее
От: John Naylor
Дата:
Сообщение: Re: Add palloc_aligned() to allow arbitrary power of 2 memory alignment