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.96) (envelope-from ) id 1vxVjE-00GkTE-2K for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Mar 2026 19:48:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxVjC-008YHb-0D for pgsql-hackers@arkaria.postgresql.org; Tue, 03 Mar 2026 19:48:22 +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.96) (envelope-from ) id 1vxVjB-008YHL-2X for pgsql-hackers@lists.postgresql.org; Tue, 03 Mar 2026 19:48:22 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxVjA-00000000IyH-0EBP for pgsql-hackers@postgresql.org; Tue, 03 Mar 2026 19:48:22 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-65f8c8c3a4aso11283618a12.2 for ; Tue, 03 Mar 2026 11:48:20 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772567299; cv=none; d=google.com; s=arc-20240605; b=h9TxYEPBidz017KRHsfyVjEHHo88/favLY1bDHoW1QNE3VM+6mCtbZleyJ/5/B4CGM GD9CYIYkhwSZG4bd2/VF39MjQKzHp5y3yDfsGPCxvSJFv0W7zwQtQLlrVoSKaIs0r4ea uhw62WNoOtFeaG971D2KdWs/Dd/BAI5nD7zyU1PigUhJ4/CAHmKuVFKQ8o0BJb6c02zH LeZs/JmhI9Wh2jzN5wwvu/hD7CnHCz1s0InQLLXV9KvDz2IOgY4voaEwf8ibrev0MfBe qfedM4y6iLDbBC5uwkJtroMkQTlPCBRzvtCCRzsxSAFxMUzfxdre2aueqZ+35cleKk4z Bi9w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=5LsegyZf7RGVFLuY01o5ywqnFaW/BjKOFW6lqiV46Io=; fh=OMQjHUNNXpvrEWGjaD2tSN9Qzj3qzLZOr1CYX4biKHo=; b=e0v1nYC7QevnLp53TzfN5soN8YSjZgPQY86/qijo47yDNrAlra1qHMkTSHx25ThNh6 +4by0S9jPH4uPw4vXHD88n0S4MiecJ3CNbWNfwT/yAHISMh4F5zaaMvFoxeKSNb+kKOd DyOEpaCA8bbrBoHwF+zDjB7mWNh0aKBmg+JW1Gme7t8RMo8KXMZdhgRvC+J3Ce15PW5r NokdcsB0ON0mdG/WqxzKnljOrWZ2MoPejSU744ExvwDEOcafAwjjCRh8eqG83Aioeh/5 v/nH5uINqAVRbzYoGUCCDSn2P9aK1RslGEpLxhRaUFkhDLLaPKy+zW28IhhLM9B6O5Jv 7NYg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772567299; x=1773172099; darn=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=5LsegyZf7RGVFLuY01o5ywqnFaW/BjKOFW6lqiV46Io=; b=hgfmwf3Er0SUosZ23mRVE7XqyqXERBPzYchKBodA9m1ZwxR+zQ8K1PHM4vvF8yrIsB qxhnpgTmycd+oay1cWFuMtrrd02lydBj8WjuGvwg0m/0EY0eB2CO/d6E0vgXHWS533B/ ACoFTfdvckGVAy+khthHR6Er/XuQEAvYPEvvbfohOrzikvY7VO1HnL4gu8jOt1Jx2nrQ OlrlJE4QQS0No6x+4v517p9bGQuKr6t3MScIXHmCb7YL059qgkb+TKXAtNU9IEKOO9Vb MjeTPKSnX8AcmTcCUXPr0MZMbjr+wqJ6WbmrQDsq1oSiN/KxmzICxs0uhII1RslO9iO4 m8vA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772567299; x=1773172099; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=5LsegyZf7RGVFLuY01o5ywqnFaW/BjKOFW6lqiV46Io=; b=G/L+FCvE7TNA11nwNaYXFNUCoy4KNyQLW7b/hpIzpQozK7vdOzeHgkgtd227an7x6d LpftL8LvBVK/OJJ6lWSkvLjQyx4fcmyxPLEUuCTMF5HgtJQz+TauJ0AN8b+No1zkRh03 595YR5x0jswP6YqxpeOaWJGTXbyxoh39TCJHCBYaZSy9UJ157r1CWK+qV078cwYoP6vy bYJQY8zEzijZtUq6lqyDxLAmrScx81H7htuwRsgBviJhcJjyJ88CHaDUGAnZeX1eRMIl sIZH+xs+vzInX9CuT8ekAsohiy3Yh6R3Wc+TykNILcW1FDoV2V7vIxwwfMWzWC9Tmtm7 f5Kg== X-Forwarded-Encrypted: i=1; AJvYcCXb/i7HZEspKShhw4t7d87J7/mcquF0HVv4exmiUxMdMSH8xe2M3vvTbGAMBs3TRGNdXNrF5gVetcOAw/RS@postgresql.org X-Gm-Message-State: AOJu0YztCf9u+rSRssVCMvhqwuwKGqAzvk3yzoXN5gXKQf82xRWQvmkP wEyf/HwZVJcO9eSb2ADxumRt6RswYqdgk0qdulZQFLXVOe0WhaOP9tde33YO75YaiWV9bmFGZIR +QQsCQ51a68kB1CtVSQGWFTr+tXDPH/A= X-Gm-Gg: ATEYQzxhVQEoYWKAWbauKsOWsa3TdaeON7i7AFYoSpLJIC85yJodFBYpo0SbrA2T0qL TmAYSZhbel+aPASzYkFu4kgmHkobmQ3l80csrHRbOpSxmHWrVdTqsGJuCYHORDypgM71L6i8cdl CbpmIB5a6nQhccKa99EPz3cYlb3vr2J0DvzLnUwRJn+bU9iy7hT+zuD3LuVun9X6SsuHu2pRON4 PO6EZLYEPSpPEFOtA6cioIeGqb+GALHmW8hiKE5dBZmXMI0/sTSmUzzWXJtUH4JaK+jbU9nL3si yPy+n4qfvOb4DDZwEbn6+xLLvoI3fT3zoOcG9EL/rlmlH3/Sl9YEJ2mKTV1e9tkFbRD3GKgwWPt nIvUN1iua X-Received: by 2002:a05:6402:a00d:b0:660:d9c1:1919 with SMTP id 4fb4d7f45d1cf-660d9c11a09mr469800a12.18.1772567299265; Tue, 03 Mar 2026 11:48:19 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Melanie Plageman Date: Tue, 3 Mar 2026 14:48:07 -0500 X-Gm-Features: AaiRm51szogzSYw_FCRfXI5W12dm0VJ7_qKHjlL8NYaWPw0EMu3kLdHkQfw-V68 Message-ID: Subject: Re: Don't synchronously wait for already-in-progress IO in read stream To: Peter Geoghegan Cc: Thomas Munro , Andres Freund , pgsql-hackers@postgresql.org, Tomas Vondra 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 Mon, Feb 23, 2026 at 2:27=E2=80=AFPM Peter Geoghegan wrote: > > Have you considered making ProcessBufferHit into an inline function? I > find that doing so meaningfully improves performance with the index > prefetching patch set. This is particularly true for cached index-only > scans with many VM buffer hits. And it seems to have no downside. Done in recently posted v4. Thanks for the report! - Melanie