Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring

From: Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Robert Treat <rob(at)xzilla(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jim Nasby <jnasby(at)upgrade(dot)com>, "Burd, Greg" <greg(at)burd(dot)me>, MARK CALLAGHAN <mdcallag(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Tomas Vondra <tomas(at)vondra(dot)me>, Nathan Bossart <nathandbossart(at)gmail(dot)com>
Subject: Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring
Date: 2025-09-09 12:51:13
Message-ID: CAKZiRmz+NSnQNLZR9CBKd6zctNs22ae48TcDNnh7M2g+SpOmiA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Andres / Robert,

On Mon, Sep 8, 2025 at 5:55 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> Hi,
>
> On 2025-09-06 09:12:19 -0400, Robert Treat wrote:
[..]
> > > [..], but 6.1 is the LTS kernel, so plenty of people
> > > are going to hit those regressions with io_uring io_method, won't
> > > they?
>
> I doubt it, but who knows.

RHEL 8.x won't have it (RH KB [1] says "RHEL 8.x: The addition to
RHEL8 was being tracked in private Bug 1881561 - Add io_uring support.
Unfortunately, it has been decided that io_uring support will not be
enabled in RHEL8."

RHEL 9.x seems to be all based on 5.14.x (so much below 6.5.x) and
states that uring is in Tech Preview there and is disabled, but it can
be enabled via sysctl. Hard to tell what they will backpatch into
5.14.x there. So if anywhere, I would speculate it would be RHEL9 (?),
therefore 5.14.x (+their custom back patches).

> > > I can try to prepare a patch, please just let me know.
>
> Yes, please do.

Attached.

> If they just upgrade in-place, they won't use io_uring. And they won't simply
> use io_uring with this large max_connections without also tuning the file
> descriptor limits...

Business as usual, just another obstacle...

-J.

Attachment Content-Type Size
v1-0001-aio-warn-user-if-combined-io_uring-memory-mapping.patch application/octet-stream 2.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kouber Saparev 2025-09-09 13:07:45 Re: BF mamba failure
Previous Message Ajin Cherian 2025-09-09 12:06:47 Re: Improve pg_sync_replication_slots() to wait for primary to advance