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 1vP0EM-00H97j-1F for pgsql-committers@arkaria.postgresql.org; Fri, 28 Nov 2025 15:17:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vP0EL-00C484-08 for pgsql-committers@arkaria.postgresql.org; Fri, 28 Nov 2025 15:17:53 +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 1vP0EK-00C47t-2Y for pgsql-committers@lists.postgresql.org; Fri, 28 Nov 2025 15:17:53 +0000 Received: from mail1.dalibo.net ([51.159.93.128] helo=mail.dalibo.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vP0EI-0020Ub-2b for pgsql-committers@lists.postgresql.org; Fri, 28 Nov 2025 15:17:52 +0000 Received: from [192.168.0.7] (5-49-10-71.hfc.dyn.abo.bbox.fr [5.49.10.71]) by mail.dalibo.com (Postfix) with ESMTPSA id 234FE2676B; Fri, 28 Nov 2025 16:17:48 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=dalibo.com; s=a; t=1764343068; bh=nceAoFzoCr1cVHb5D2R6uIg7vqfOsk3q6iuEURzNPBU=; h=Date:Subject:To:References:From:Cc:In-Reply-To:From; b=qF3QdjY/kp2kC0kvLiQS2tFIQygxV+UAkZOxFdo+Ti041i6UhahH7v+swZxPf3+cC 3+l6Rqzt61Z1QYcQau81mQRZGriUQ8rwjrqBvgSqRUL2QjSXq9lWVCO9rjIKgyXuq6 QdkLdrI2okpk2ipML9KfWLuJtyFJFsIhyXTARA7o= Message-ID: Date: Fri, 28 Nov 2025 16:17:47 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgsql: Increase BAS_BULKREAD based on effective_io_concurrency To: Andres Freund , pgsql-committers@lists.postgresql.org References: From: =?UTF-8?Q?Fr=C3=A9d=C3=A9ric_Yhuel?= Content-Language: fr, en-US Autocrypt: addr=frederic.yhuel@dalibo.com; keydata= xjMEXn3bgxYJKwYBBAHaRw8BAQdA6tX5FT/n5ztMWIoBdl6k5avvu65fv6ryfVzIx/aH3V3N JEYuIFlodWVsIDxmcmVkZXJpYy55aHVlbEBkYWxpYm8uY29tPsKWBBMWCAA+FiEEi7OTyf6H ePS+C6n11XGWhN8zGNUFAmZDVJ8CGwMFCQtfi90FCwkIBwIGFQoJCAsCBBYCAwECHgECF4AA CgkQ1XGWhN8zGNV65gEA6o+UrebFjn2CIAOYwP3CiiJugiM5TMH9yJyehQua5ZoA/2ChxiVn 8OUaAw/ErxJmQi1mSN0tNZBL/KhkUPBDUDQNzjgEXn3bgxIKKwYBBAGXVQEFAQEHQCuh5cLQ AtEBXHa2Fmtp0kduBu7msM7qO/gaEcdjFUdiAwEIB8J+BBgWCAAmAhsMFiEEi7OTyf6HePS+ C6n11XGWhN8zGNUFAmZDVJ8FCQtfi90ACgkQ1XGWhN8zGNWOOAEArSqePBqfd4Kx4ulACaWO 6fM+XSDfUlBAQXx9rU6DR4MBALwozl9g91tRysim6lKxggvBfp/PvbpTZNrxYLWB2fYP Cc: Christophe Courtois In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Le 08/04/2025 à 08:52, Andres Freund a écrit : > Increase BAS_BULKREAD based on effective_io_concurrency > > Before, BAS_BULKREAD was always of size 256kB. With the default > io_combine_limit of 16, that only allowed 1-2 IOs to be in flight - > insufficient even on very low latency storage. Hi, I think that backend/storage/buffer/README should be updated to reflect this change. Unfortunately, I don't understand the subject well enough to propose a patch, even though it would probably just involve copying and pasting your comments into the README.