Re: Postgre and AIO

2025-10-18 Thread Dominique Devienne
On Mon, Sep 29, 2025 at 2:07 PM Weck, Luis wrote: > Now that AIO landed in v18, > [...] index updating happens one at a time. > [...] it took a long time sequentially reading the index for each value These have nothing to do with Async-IO IMHO. For your first case, each index is its own file, so

Re: Postgre and AIO

2025-10-18 Thread Xuneng Zhou
Hi, On Mon, Sep 29, 2025 at 8:07 PM Weck, Luis wrote: > > This is more of a question of capability and to make me understand how > exactly 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