Horton

Re: Should io_method=worker remain the default?

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es
From: Jeff Davis <pgsql@j-davis.com>
To: Andres Freund <andres@anarazel.de>
Cc: Thomas Munro <thomas.munro@gmail.com>, pgsql-hackers@postgresql.org
Date: 2025-09-08T21:46:26Z
Lists: pgsql-hackers 
On Mon, 2025-09-08 at 17:02 -0400, Andres Freund wrote:
> I forgot an addendum: In fact, if there were a sufficiently cheap way
> to avoid
> using AIO when data is in the page cache, I'm fairly sure we'd want
> to use
> that. However, there is not, from what I know (both fincore() and
> RWF_NOWAIT
> are too expensive). The maximum gain from using AIO when the data is
> already
> in the page cache is just not very big, and it can cause slowdowns
> due to IPC
> overhead etc.

Also interesting. It might be worth mentioning in the docs and/or
README.

Regards,
	Jeff Davis

Commits

  1. meson: Build numeric.c with -ftree-vectorize.

  2. meson: build checksums with extra optimization flags.