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 1wbvyr-002xWM-2T for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2026 07:55:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wbvyq-00ANZJ-24 for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2026 07:55:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wbvyq-00ANZB-0k for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2026 07:55:36 +0000 Received: from mail-qk1-x733.google.com ([2607:f8b0:4864:20::733]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wbvyo-00000001iEF-2zRT for pgsql-admin@lists.postgresql.org; Tue, 23 Jun 2026 07:55:35 +0000 Received: by mail-qk1-x733.google.com with SMTP id af79cd13be357-91588056619so381153085a.2 for ; Tue, 23 Jun 2026 00:55:34 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1782201333; cv=none; d=google.com; s=arc-20240605; b=itwyrEo5xA6oNRsfbEjgzAseUiSKJNCag8zFSJOT9CYgBgSP2Dgp8+njL+uyQLZU9Z L30kdrHVlAnUJCIL3BR3X8tzXs4P2c7jtXq2XRyUsPK9zEcDwRfjL/cYIo62DM8rbYlS gEXF/qUQRFU0DzQskKWNFw686nEHSsmOebw/lXFsf8KZ8qn41oloVDenomp5b/7f1Lne Q5rV+CH9GPulKsVrW9M85yluQZu97hEAsoWmO8ypNiOVfR3eAQhc3CjcLxXrF3NaQWNF 6wW8R5dnC/aRvTnKg9JBcO0gmY3uQ2lzbFMQ/EvRTDb7ktzrgCMZi3y+0DWf0aTCTn7z vMMA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=PDocmvAiBPNdT/W8B2sszB6kOFgdQo79mPatq/4lv8o=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=Ajk1pP8GE4Tgqt0hqV3PPMqrW8/gKHsnKzyJ70WHFU/xBui4OzUmBSM3uEHK8mHmJr RddMFhJBKEyF2XFTolvGUnE2UPorY69YaFAQ4AQf7NnbK0A37mCqQNri5lEAC0RSWP4w 9E84Y6FaZnumUAR/akkNDYYJ6G8BEYyDFgfmQeddlFTdk3nrwKwNwXzmZF8JbCmJdth1 hxPzdWaXKs0nU50ER6y15jWPIfbtZwXHRdD38EHj27UEwnO0Tt859WsCpC85PjQOVKi3 0z43dpIbj9M9JI7QW45xsweRTOK1N0AmpMS7AnjFo0TM3HYW0q2YAgSxfsoWUn4rfNi2 KU7Q==; darn=lists.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=20251104; t=1782201333; x=1782806133; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=PDocmvAiBPNdT/W8B2sszB6kOFgdQo79mPatq/4lv8o=; b=NKjqMAYHLh1JvwxKK/Pj+LwOaM32M26v4JWeu+ixPkW6/MnLVCrBD3ouugflfwAVOE KIYG+hJfuH0cCalKnGcEYsgKk0GmqoriTpC2nQq5ic8d8Nm/+V7k5ruGhMPgR5wQVIav T/9WBWv8x/2Me89JCAIbiOFF3O6P8GyTz/91jY5CUTgjqkvFu5w/ovGqgRwqD4Dstwzh fC2oOElF5ivP3aNDI1yFZjPzcsVq9PuwNk9tAGb/2nX3lYF8uX2vNIWpg3pEo3ZKmTfm Ls1mc4bLp7ed+0qIDQ1FTFPVcBwWHBKS8LPTCTej71Zf/9Axhmtqxpzs6fx84dP6RVt4 lLKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1782201333; x=1782806133; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=PDocmvAiBPNdT/W8B2sszB6kOFgdQo79mPatq/4lv8o=; b=qldzWk0EeVD6yakzV87DY6Gnlxf0QYg8SZqamKFGKeINl+V5yJFrfpNzwA0Z2Xyw5Q 5HZJ43DvRR4tD24VBffFrr2t9FdgKlPkmgkf5v+JljfrL8xpJSWpkVbKO/K8WgJwNYKD YVsDHogagH9sp+OpiX4L8XYVVGJ95L4gATxksx6gQYwzpb07r+Nk9/0GeeTd7Rgiid6r npSdAt2BLnehfOg2z+CT14DdORxISAKzke55ZJ5sEDB4DGST9qUrQLzIW/sNrn56rTa6 O3AqerOWKR8gZhryoehuBVtws48LPCbrwlJxVL/NzQLhgrzfsyO0YREJMrfQc2qdzfLK 1WJA== X-Gm-Message-State: AOJu0YzAIhRlGg1qEMMozNUPkweQK7627L4U/DDzPsTAv1wNWJi+WeRA 2Ln0aOVHO6/DpWemYKXZ1wpAuNdF8E6hLjtNowW9h829dkB/Ipis5ZIVdT1WRByv6xmCt+zgrx2 k6qdC1gDRTGimor81HuXFIysP+/pRSI17EA== X-Gm-Gg: AfdE7ckvJNE+5l4/CXWvU5EZP2AR3hddBL/DH3iwrnfQrpkrOS3pitHfpH2oEYbL/Ew 1gAMUT7lGRKggIp/2t2PGSI6nn5dk3EhxiveBxbHDHMCC4vHXPkFTr/pw2AyPEOANcrFQv+N6nw qudyzTfE3b+pHeN/IbwOTizCQqM2OefkO7VNg9XlRjGIMQ1IT8SARZ047p5IrFkPFf68VzFYc8G c3D5vQLayqCX8ZD35wmLBoMlQa3ExTeHmzjqjoX3fNB8YdlyS634ecf+ao+DeJHv16u+pjgMihO +VJ29hKXSWu4TrUrP5BxbSa8QETXVeQ= X-Received: by 2002:a05:620a:269a:b0:922:9cd7:897f with SMTP id af79cd13be357-9229cd78aedmr1811036485a.4.1782201333423; Tue, 23 Jun 2026 00:55:33 -0700 (PDT) MIME-Version: 1.0 From: ek ek Date: Tue, 23 Jun 2026 10:55:22 +0300 X-Gm-Features: AVVi8CeQWpyBhxRpujHKHnm5WLlpoqG4XzL9oTJ1MjMtHppncBrMK3kUE2_M66Y Message-ID: Subject: About asynchronous I/O To: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000065a3450654e7152a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000065a3450654e7152a Content-Type: text/plain; charset="UTF-8" Hello everyone, Are any of you running PostgreSQL 18 on production environments sized between 1 to 3TB? Does the 'asynchronous I/O (AIO) subsystem' deliver a significant performance increase? Also, has anyone had the opportunity to benchmark it against v17? --00000000000065a3450654e7152a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello everyone,
= Are any of you running PostgreSQL 18 on production environments sized betwe= en 1 to 3TB? Does the 'asynchronous I/O (AIO) subsystem' deliver a = significant performance increase? Also, has anyone had the opportunity to b= enchmark it against v17?
--00000000000065a3450654e7152a--