From: "Weck, Luis" <luis.weck@pismo.io>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Postgre and AIO
Thread-Topic: Postgre and AIO
Thread-Index: AQHcMTfCyjYjOC/QQUSQylSc6HJzjg==
Date: Mon, 29 Sep 2025 12:07:09 +0000
Message-ID: <IA3PR10MB8113DB0A2CA1B6B0DE3831078D1BA@IA3PR10MB8113.namprd10.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
msip_labels: MSIP_Label_a0f89cb5-682d-4be4-b0e0-739c9b4a93d4_Enabled=True;MSIP_Label_a0f89cb5-682d-4be4-b0e0-739c9b4a93d4_SiteId=38305e12-e15d-4ee8-88b9-c4db1c477d76;MSIP_Label_a0f89cb5-682d-4be4-b0e0-739c9b4a93d4_SetDate=2025-09-29T11:54:06.5593493Z;MSIP_Label_a0f89cb5-682d-4be4-b0e0-739c9b4a93d4_Name=Not
 Classified;MSIP_Label_a0f89cb5-682d-4be4-b0e0-739c9b4a93d4_ContentBits=0;MSIP_Label_a0f89cb5-682d-4be4-b0e0-739c9b4a93d4_Method=Standard
x-ms-reactions: allow
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=pismo.io;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: IA3PR10MB8113:EE_|PH7PR10MB7767:EE_
x-ms-office365-filtering-correlation-id: 658bda1d-9d14-47e2-04e6-08ddff50b73c
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700021|8096899003;
x-microsoft-antispam-message-info: =?Windows-1252?Q?jy1w5yxcYt5zDmgVBjejqe2EhqPvIk/NwmkT6MaYvnI/z/FZbNwKRZ4o?=
 =?Windows-1252?Q?Zs6VLzURhEMUl1VQxCSC3hFnoI+jEhKgxCQNC1iC7ez4ZesvFjPuWwEh?=
 =?Windows-1252?Q?nQr6ViIDFjwML5H7Ld4AHJ9Yh2/zeBVci+ZHIFcoPB792p99/pdJYKWS?=
 =?Windows-1252?Q?WjytylUmyEzJ1HKRXAb4OSdVKN1fFauN+jMJtgGawNSP62XDnmO4I6nH?=
 =?Windows-1252?Q?RTsOA1HzdYmzvYVnuSsmDmCVB3Ce53v7wXQPe+9zioHv4dvK4R0HTgMO?=
 =?Windows-1252?Q?ZEvyOhQkjH/ZiZpKUxutvm62s4M6ReATW3qmt4uW+4yn3ks2PR+TrZSp?=
 =?Windows-1252?Q?bhCrF4/UMTeE3Xw9MWh86Et0G074jHJDsXTk6H8N5rpm+DXdCXaX+9s8?=
 =?Windows-1252?Q?roYnDwS+ry4GreEYGoZyre1GAMjdhIT+N/UclrPii/6keWBZpIMmV/10?=
 =?Windows-1252?Q?LrNP4fJuYtITs6bvBv74cFQLO84ZpIKGWarr2U0mXhTtR+JCrr9tpIxv?=
 =?Windows-1252?Q?FqlXXsmB/mNrpls35a1RXLPm8gRNlBHuY34ERNN0sXoeeQALBgKB3uVi?=
 =?Windows-1252?Q?JVcxTgKq3wMQfU1bkM51qJmlGlsm8l+z+dWZLhq4kjN1fhcskYE2xqGW?=
 =?Windows-1252?Q?UEE7VF7tBr5D3ouejPOxLcDgIBPmO2fCAlyhT5xVEIfhBsRjf/f2+d8M?=
 =?Windows-1252?Q?/wStvpbb6FX/NRsv+AdVMPsFlpIlL9fsAg6HLDEIZGYuvrUBVnBy82qZ?=
 =?Windows-1252?Q?jn/Q7vE5YI7mGo6L4oqHmA+5J5DM8XzkEGBv2p87ME1/TWRBS0bDyoUE?=
 =?Windows-1252?Q?1b7wqG6jr0KXd1dZv9wT52NUDbVF25F0ivXuK13XMIPqxSlWHSIhnFLx?=
 =?Windows-1252?Q?0MkwmGloyZjTo/qbCx0wiF3C4neCyO71Zgt6j2Xp2ezZEtZ4bTcwX2NF?=
 =?Windows-1252?Q?290ELU9RBQ0ueHyMWixaoSIAQGK/vZE5Vd3fhLUNc3TTYVPaAOnJv00o?=
 =?Windows-1252?Q?6bL9nQD7gXhY0uInj/CiTo6qFosy2kU+Du6+ruKFiUCeP6/6y9gaSymr?=
 =?Windows-1252?Q?GhGA4+KxdwutrQZVSMdNuwgb9MEJUN5hlFRom9yvpfu6HWwJOxWa2Xz7?=
 =?Windows-1252?Q?NCWLtwingxaUiPGcDNamZelEWKiCG0+Qt9gh+ToffKkg04k8jLO81Dk6?=
 =?Windows-1252?Q?hVwMAQD2CT5PW2TTdSKL3G9x1qWPfz4RjQoogSJEIhlgTqWD5ndJKrYC?=
 =?Windows-1252?Q?5HazP4pJkbWzqosxaFGD6ZqNTDzsxO2Eaxv9oU75OkuPcjFO3R567QCg?=
 =?Windows-1252?Q?3P7jf9Ek0N0zkc6KvgjHIgzZkqji6KH8r1mb1T2030G2JefAdJY1ukC5?=
 =?Windows-1252?Q?Lh5mtfN48vIqc6INUXARKAS4+ryOmhnmaYPLWm+yhqfQbyVOHK4LNUsE?=
 =?Windows-1252?Q?xxVcacrlw8iKxCniHKsKVwpD2q+6GcVA7U792yIQVJocR4oBAR6R7Xf1?=
 =?Windows-1252?Q?8izeOowYobhSoKMRTkZz7t1F2I6AEevUFmW53JfM0ObHkcQXaYHXBFzi?=
 =?Windows-1252?Q?NoGelgJL67CVbvKtGDF4R5S7RS/hZl0XjuVrY4Pt3pW+YQykG2gvfOva?=
 =?Windows-1252?Q?K90ndfDJ3iEGpYYkk2Wdm2KC?=
x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:IA3PR10MB8113.namprd10.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700021)(8096899003);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?VPC6g1qDhdFar7qkuX7QcyXPhOS//HC/VgEr2UmlwjLOyq9HH5r4fu/3?=
 =?Windows-1252?Q?SsPNBpMSTZtYa1S3g420EG4q2CoZc6/u0cZnO796/pzZDvNw05i06TR5?=
 =?Windows-1252?Q?KkAd5LnbWB9aGEP5EQo95AcUzO7y2MAXO08u2HN6OfcaksJoCUCiQWFU?=
 =?Windows-1252?Q?jn1VwDYZK6U0z0aaaswtCs1Miry3ip7U/qIqn9HCICtYYek1Oif4rOzF?=
 =?Windows-1252?Q?AgFrXf1UPnPF6lmwqqnyUjUIBxoZ4P9BfkPsCejd7OAba951G37b8m9I?=
 =?Windows-1252?Q?Sg5Q4xeZyH9kO3Ny6arjwPsgLJqoFTnEYobGJQVGQbX8K99cKR4t+tGy?=
 =?Windows-1252?Q?AynVC6DUVGypgFCV2Rrv6HaDIl2qHvAm/VZAJzVzWf0ruBK1CUwpF//S?=
 =?Windows-1252?Q?W5NOCv1Cn5CbqcHifjSMDIjjgrRJOLP4nwzC4qlGVjyTIzoXEFqx94yL?=
 =?Windows-1252?Q?JteQ0t7qytWYV/14VU06iZoKyq3RUzI3wnCnC4MmzmYFxJpGHJXmmlUm?=
 =?Windows-1252?Q?NoXNGAbrySivDkt2p51Fs5L6INmrjG7W13W89NFHCInh0IvLvpOeBOAH?=
 =?Windows-1252?Q?vtqub6HrxIxn786YLNR9F/WcVhZTCwSSntXFcOFVzvacQgXrixhw96tm?=
 =?Windows-1252?Q?FFIrTevrrVIhqbV4p3b2Vg1oaHeCcit8Ul/z8KD7J2auUYmUNOs78sH+?=
 =?Windows-1252?Q?ujW7hzuE6dNYvSAHoRhntyAkj/IdbPXR3hhAAO24fDnEj6XUr5FejW2Z?=
 =?Windows-1252?Q?SfjNZsTDMm/v+2YBFyxHe592ayhQFAjG6lUfcdRlaOKWORirWsIciUZ6?=
 =?Windows-1252?Q?g4JmcqwSU/epp38IJ8Rq2cFAQE+V5uigXiaMS77YgFboZZg+15R9obVl?=
 =?Windows-1252?Q?oRQPbQG2M6uGCSPmD5y++nxdIb8xiTX1gcevDPxoAYPif1cCpJxTynAr?=
 =?Windows-1252?Q?IG/zbHzhePVi0duMc9BDZ3O+IgIJi0SIzJRtpsVNFlZG3pgSo1wBJ4lg?=
 =?Windows-1252?Q?eKbB1WIYe5bFf85oQ/b5BWUyA4zBNkSy/H9JHdIZpMoM9F3oQZVjnMK9?=
 =?Windows-1252?Q?OJdbEJ/X79HpdqzE/njCsL0hO2lT5LUYA7WFD6IzD1hRFRX1ubD6M0C9?=
 =?Windows-1252?Q?1otFVsbPzfMyEK4oztPQQ5U7f5blHsI8fYSnDtY0fXrBOxqokRESrKrK?=
 =?Windows-1252?Q?koC+8rEOAo/bCUSXJTp9HHHgOr1UyvWmx6o6B6z7ji5dRdxqVq/Q7hAk?=
 =?Windows-1252?Q?v2x5tlgxYEIipvrlCQ2V2eQYdpMroPn6y94tAATyuOqE8drBOcIN4LiJ?=
 =?Windows-1252?Q?WkE18NxZVTi6GAUMmWCL8p1EtXYbJ2YQz+LoJ5HJscShwc1hUxMvGHQ+?=
 =?Windows-1252?Q?PM5w4c9gcGNKIYltbupuMoQVfj63cEm0ve2ESmoxTrr/cX4a5+r+BO2J?=
 =?Windows-1252?Q?OouoiRAbEeOFI26lKNi/VkHF/vBdCxk9vkXjtpodrtE040/HKtKUgpta?=
 =?Windows-1252?Q?jYWGpTJaTeMFqwBhIn/Lq0bTZlQDBUM6X90ECyk2MKYRK6H0vuwERVrs?=
 =?Windows-1252?Q?MdSr2HKxrqwh1h5qlIpS6zOOZiGzFGsOnmmj9mwlMhI1NsMqwHXDmVa3?=
 =?Windows-1252?Q?R2b3bkyY40775UyT874IJW+baHL+kNZS8pqoCXCm8B+l2I/yXVbV4lsU?=
 =?Windows-1252?Q?/2RZyr+SZj8vYXZUCwJkSfe4LvDa6+3a?=
Content-Type: multipart/alternative;
	boundary="_000_IA3PR10MB8113DB0A2CA1B6B0DE3831078D1BAIA3PR10MB8113namp_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: IA3PR10MB8113.namprd10.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 658bda1d-9d14-47e2-04e6-08ddff50b73c
X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Sep 2025 12:07:09.3062
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 38305e12-e15d-4ee8-88b9-c4db1c477d76
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: WkGL28Xba0rhJ9yrm0KiK9Wbf8xmySu+PPlcybuX28vPoNu7bi31W8WOj4LwAlYs
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH7PR10MB7767
X-OriginatorOrg: pismo.io
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/IA3PR10MB8113DB0A2CA1B6B0DE3831078D1BA%40IA3PR10MB8113.namprd10.prod.outlook.com>
Precedence: bulk

--_000_IA3PR10MB8113DB0A2CA1B6B0DE3831078D1BAIA3PR10MB8113namp_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

This is more of a question of capability and to make me understand how exac=
tly AIO work in Postgres.

Now that AIO landed in v18, I was thinking of a use case which has annoyed =
me sometimes, which is inserting  lots of data into a table with many indic=
es. What I am specifically =93complaining=94 is that index updating happens=
 one at a time. Would it be possible/make sense to use AIO to do this?

Another thing that happens often is that an index lookup for something like=
 SELECT y FROM tbl WHERE x IN (1,2,=85N)  where N is a big number such as 1=
000 or 2000, takes a while, because (at least for versions < 18) it took a =
long time sequentially reading the index  for each value. I ended up having=
 to split the values into smaller chunks and ran multiple queries in parall=
el to maintain a lower latency overall.

Anyway, does any of this make sense? Could Postgres extend the use of AIO t=
o such cases?

--_000_IA3PR10MB8113DB0A2CA1B6B0DE3831078D1BAIA3PR10MB8113namp_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
This is more of a question of capability and to make me understand how exac=
tly AIO work in Postgres.</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
Now that AIO landed in v18, I was thinking of a use case which has annoyed =
me sometimes, which is inserting &nbsp;lots of data into a table with many =
indices. What I am specifically =93complaining=94 is that index updating ha=
ppens one at a time. Would it be possible/make
 sense to use AIO to do this?</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; color: rgb(=
0, 0, 0);">
<span style=3D"font-size: 12pt;">Another thing that happens often is that a=
n index lookup for something like SELECT y&nbsp;FROM tbl WHERE x IN (1,2,=
=85N) &nbsp;where N is a big number such as 1000 or 2000, takes a while, be=
cause (at least for versions &lt; 18) it took a long
 time </span><span style=3D"font-size: 16px; background-color: rgb(255, 255=
, 255);">sequentially
</span><span style=3D"font-size: 12pt;">reading the index &nbsp;for each va=
lue. I ended up having to split the values into smaller chunks and ran mult=
iple queries in parallel to maintain a lower latency overall.</span></div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; font-size: =
12pt; color: rgb(0, 0, 0);">
Anyway, does any of this make sense? Could Postgres extend the use of AIO t=
o such cases?</div>
<div dir=3D"ltr" id=3D"ms-outlook-mobile-signature" style=3D"color: inherit=
; background-color: inherit;">
</div>
</body>
</html>

--_000_IA3PR10MB8113DB0A2CA1B6B0DE3831078D1BAIA3PR10MB8113namp_--