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 1w9Fxy-001Iei-1q for pgsql-hackers@arkaria.postgresql.org; Sun, 05 Apr 2026 05:24:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9Fxx-001d6E-0P for pgsql-hackers@arkaria.postgresql.org; Sun, 05 Apr 2026 05:24:09 +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 1w9Fxw-001d63-2i for pgsql-hackers@lists.postgresql.org; Sun, 05 Apr 2026 05:24:09 +0000 Received: from fout-b1-smtp.messagingengine.com ([202.12.124.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w9Fxu-00000000gB2-38zK for pgsql-hackers@postgresql.org; Sun, 05 Apr 2026 05:24:08 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfout.stl.internal (Postfix) with ESMTP id C6B1E1D00060; Sun, 5 Apr 2026 01:24:04 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-06.internal (MEProxy); Sun, 05 Apr 2026 01:24:05 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1775366644; x=1775453044; bh=ghyeEUe6Tt qryjpFYDNRmqjEC/Pbeg4gE5ODMojvdFo=; b=RCHfAq5iV10XYF+38636dqgwGs njmV3vvRoyatZ38UQYcRsbBa7WmRFBTr2tqxKlgphbb6cOJMQ6GJ5zMBe9eihdjY hRj7H4GV5SN+lBSplmJl5TWg2xgZV7UuCj//Q2CSFPuvoxCbQ3xMXmXV0nMfCqAR 7ZaTy3DoO7zgX30aoLbi5tZSTpmyM3P2I89EUqONztddMoMQc/QJJvK4wc5U/t0H 9onB4tBW3Vo7m/klIG7cRDHiLhYCUNu5qkyIQBCNVB3mP4QurLR27rumANOh6LY+ bfilIRu3sC7RvhV3iKdHr7IZ1IQ5Hf6uvZXrtfkXz3i1i9y3nrL4kO6Tlyxg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1775366644; x=1775453044; bh=ghyeEUe6TtqryjpFYDNRmqjEC/Pbeg4gE5O DMojvdFo=; b=gTaggyCuGt46uKtEG7Rv5gHjbZfdvX9Xfbn+rnCsa9zRZO0q4J1 oayFLNsEoB1FQiLkKH56X1ZEPEXVOFLe+G9vDk2KleJZ3CrNVOr5dWen0Hk1YnDh HqxT7gLsUraacN0F+5tSDF5bfC3ob10N+MKuRmk0JTYPW+5nRtI13u8k+c0y+uzA WkvHQIpJYRzokTg++xPCmsnTlHDR84i13/wqd505TWf/s+aEdXH3turcPyY7AI70 oo7/xXK+wTJajtFTOVmTXBHVhnikfeCvdxOYkHEur7egbn0GG+JlNGwzcqyzKGHc lMLsgbo7YRVNvsLJM9k7tSnUbO1Pm7Ik8ow== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgddufeeklecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfhfgggtuggjsehttdfstddttddvnecuhfhrohhmpeetnhgurhgvshcu hfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrghtth gvrhhnpeeffffgledvffegtdevlefgtdeggffhvdekgfegteeiveejkeetudelveejhfeu geenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrnh gurhgvshesrghnrghrrgiivghlrdguvgdpnhgspghrtghpthhtohepiedpmhhouggvpehs mhhtphhouhhtpdhrtghpthhtohepphhgsegsohifthdrihgvpdhrtghpthhtohepthhvse hfuhiiiiihrdgtiidprhgtphhtthhopegshigrvhhuiiekudesghhmrghilhdrtghomhdp rhgtphhtthhopehmvghlrghnihgvphhlrghgvghmrghnsehgmhgrihhlrdgtohhmpdhrtg hpthhtohepthhhohhmrghsrdhmuhhnrhhosehgmhgrihhlrdgtohhmpdhrtghpthhtohep phhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: id4a34324:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 5 Apr 2026 01:24:03 -0400 (EDT) Date: Sun, 5 Apr 2026 01:24:02 -0400 From: Andres Freund To: Melanie Plageman Cc: pgsql-hackers@postgresql.org, Thomas Munro , Peter Geoghegan , Tomas Vondra , Nazir Bilal Yavuz Subject: Re: AIO / read stream heuristics adjustments for index prefetching Message-ID: References: <24bjkmnkuapbs7wvcecvtrb3gvbrzg3extlkzpbg2f7dwt7h42@3e4vg6cd33iw> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, I polished the first four commits a good bit more. Very little in the way of code changes, other than comments. Will send a version of "Allow read_stream_reset() to not wait for IO completion" with extended tests tomorrow. Greetings, Andres Freund