Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uiwZd-000WzQ-BQ for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Aug 2025 14:54:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uiwZc-001vwh-D0 for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Aug 2025 14:54:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uiwZc-001vwY-3i for pgsql-hackers@lists.postgresql.org; Mon, 04 Aug 2025 14:54:00 +0000 Received: from mail-oa1-x32.google.com ([2001:4860:4864:20::32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uiwZZ-000iVb-39 for pgsql-hackers@lists.postgresql.org; Mon, 04 Aug 2025 14:53:59 +0000 Received: by mail-oa1-x32.google.com with SMTP id 586e51a60fabf-30b7eba97f5so644909fac.2 for ; Mon, 04 Aug 2025 07:53:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754319234; x=1754924034; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=8eH7U3KaksnbMGoZ+S6DHQJC13372FezydgOy0fxH+Q=; b=UPrV4VitQNdgpSyEJTzIQDK4upHqfLtr6hSiGvP8QQOIOVN3YiNHX0IvawKKLquOzz z4m/DvgCHO0ih+Gjpg4DhTSTEsqugWqk5T39g5uQkgcz/c9z5LidqgqtMb4r3llFSpHY bChCAbg2WGYjLLWx6UDg2rmgHmQdshJjJ5lnLzz9xqc5ObYV8Gl0oGDDvLtULOBnHwcb mnVHI3I1U/19iXaWStIPZ5FeSO7YVMnm/hO68jn8cspoUT3AgasS7sEuVKG0wBf3TWfb 8IuunI0Y/pqBpjxdgTBQEU1drAhpahsMmtGt07y6HvxLEHAsI0Acwn3FfEPfxN5ygl+0 sAHw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754319234; x=1754924034; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=8eH7U3KaksnbMGoZ+S6DHQJC13372FezydgOy0fxH+Q=; b=vaFonoNXMU1C17nzeedTy0cpA21sTDODyVa6HrCIV8C41bmcwlyZQtzSxdPk87277B J1D7NYG0lenTWQCCchlYteu5GCVTA2fSbERqGlL7mEzNalxmnMteIxCcVydqtM+eZujT GlxeJFrVSA718ai6d5CNM8TCu0zogsJPZRbpgrYMUofZouLuO/lJ8+3Q0JqkNNa53POi ElhcXx7lY9mBIJjrwwXLZelPYJ6nCgBQYOssdeF4ZJId6KUlNhffT6rIwgY9RamaGMFF 3s15J/W6SLg95sLvhoomW1K1ehR7zeGsedmn0VQ2dDPBI1wafbEp0DYnHTaYtlTdC8EZ 1Y3g== X-Gm-Message-State: AOJu0Yy+o5y/DaKfQz8yyHA0Fv9YziE7cKG4rn3dhhznTtEbRK4FBJKb PGHSEII87Kpsot6x3pr3jDoaMpg9qDQaGzXiAEsR8z5sUn6mgyLDDC/JhaDi5NK2C5sLn7xShFv ebD3ykXRw07dTYMEBzOw3frAs+MV6NY8= X-Gm-Gg: ASbGncvhfSBBw6FZlboVDSlXVUpgAaM25TKqemBRwpAJ4e6HCZzpv6zGoaiHA25vjwX lpxAaeFR3zzQhAmw7/KsP9GGIt4I+v5Sy0ZkErWBULcsfwaED3YINdW+JXt1K/ZT2lr4acjZQ3d wBEOjc+VPfj8XV+UV/XjK0DroXK9OCNfEtCKRrMGo2/mLfSeeCxWlxE9L0r3t9YRdoQYz5Of6RX fRfQ+/NLPgF8jzJx1ZBjXr7w8I+ibMOCEySHXKGKA== X-Google-Smtp-Source: AGHT+IHI7fIr0g46CFfWI6g960NgYneyWZgNiX9QOsLDS3WDmH1Kn6wn2BX+MTEqH08lbLWZcjaBUDbSMB/pJD7WcXI= X-Received: by 2002:a05:6820:1c8e:b0:615:eb20:4f68 with SMTP id 006d021491bc7-6198f190bd4mr1776532eaf.1.1754319234261; Mon, 04 Aug 2025 07:53:54 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Thomas Munro Date: Tue, 5 Aug 2025 02:53:18 +1200 X-Gm-Features: Ac12FXy3NaSK9LNxyCCvgA81iM9k2abudVqak1590MWcFa3H-oNiM905mDJICUE Message-ID: Subject: Re: [PATCH] OAuth: fix performance bug with stuck multiplexer events To: Jacob Champion Cc: PostgreSQL Hackers , Daniel Gustafsson , Peter Eisentraut Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jul 29, 2025 at 8:52=E2=80=AFAM Jacob Champion wrote: > On Thu, Jun 26, 2025 at 4:33=E2=80=AFPM Jacob Champion > wrote: > > My plan, if this code seems reasonable, is to backport 0001-0003, but > > keep the larger 0004 on HEAD only until it has proven to be stable. > > It's a big new suite and I want to make sure it's not flapping on some > > buildfarm animal. Eventually I'll backport that too. > > Any thoughts on the approach? Too big/too scary/too BSD-specific? > > A small bit of self-review: a comment I wrote in the tests suggested > that the choice of readable/writable events was up to the multiplexer > implementation, but it *must* choose readable, due to the hardcoded > use of PGRES_POLLING_READING throughout the current code. Updated in > v2. [FYI, I'm looking into this and planning to post a review in 1-2 days...]