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
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
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 table with many indices.
What I am specifically “complaining” is