Date: Tue, 29 Jul 2025 11:41:01 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Tomas Vondra <tomas@vondra.me>
Cc: Andres Freund <andres@anarazel.de>, Antonin Houska <ah@cybertec.at>,
	Noah Misch <noah@leadboat.com>, pgsql-hackers@postgresql.org,
	Thomas Munro <thomas.munro@gmail.com>,
	Heikki Linnakangas <hlinnaka@iki.fi>,
	Robert Haas <robertmhaas@gmail.com>,
	Jakub Wartak <jakub.wartak@enterprisedb.com>,
	Jelte Fennema-Nio <postgres@jeltef.nl>
Subject: Re: AIO v2.5
Message-ID: <aIj5nekHol8NnXKf@nathan>
References: <17906.1741863183@localhost>
 <3yxd5r23zly5bytvgyktbxtxq2r3gbpi7xd4dugevh3h4w4q6c@lu6oatjjpltz>
 <oav52ytakcvfnk52w5o5wvxdjavxth2tgptxt25gnfmh2pdcpk@omp3xukdu5if>
 <zp7obmaqdd6b5u2vhpw27hovpjirtqvjakkbkaz4vju7tohyul@4kfobe7ipgxm>
 <2dea8882-537e-46a7-a321-ed69f3041226@vondra.me>
 <i6qpoaiyjfswa6n46qd2hk3g3icbfd4i6auri7owtif46zttba@ayvgewa5x3b6>
 <e6db33f3-50de-43d3-9d9f-747c3b376e80@vondra.me>
 <brdaw5wke274lubirrl4v2k4qdacylvgwwqztifn7m27pkth3s@rh7wie47pfcp>
 <cbc572c1-95cf-4407-94b2-e54521f55e28@vondra.me>
 <21674729-87b9-4bdc-9f36-13f8072b550d@vondra.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <21674729-87b9-4bdc-9f36-13f8072b550d@vondra.me>
Archived-At: <https://www.postgresql.org/message-id/aIj5nekHol8NnXKf%40nathan>
Precedence: bulk

[RMT hat]

On Tue, Jul 22, 2025 at 03:51:12PM +0200, Tomas Vondra wrote:
> In general, it doesn't change the earlier conclusions at all. Most of
> the earlier observations apply to these results from these machines with
> reasonably different types of storage. So I still think we should stick
> to "worker", but consider increasing the default number of workers.
> 
> It's possible there's machine with storage/hardware that would work
> better with some other io_method value, but that's why it's a GUC. The
> default should work for most systems.

Given there have been no further proposals or discussion, we have marked
the related open item as "Won't Fix".  This means we plan to ship v18 with
io_method=worker and io_workers=3 by default.

-- 
nathan