Re: RFC: Allow EXPLAIN to Output Page Fault Information - Mailing list pgsql-hackers

From Andres Freund
Subject Re: RFC: Allow EXPLAIN to Output Page Fault Information
Date
Msg-id zluvsuokej5tpqirkrmhwdikg5cwhkzu2dvlpkdizlukitu7vl@yaglatfcccho
Whole thread Raw
In response to Re: RFC: Allow EXPLAIN to Output Page Fault Information  (Jelte Fennema-Nio <postgres@jeltef.nl>)
Responses Re: RFC: Allow EXPLAIN to Output Page Fault Information
List pgsql-hackers
Hi,

On 2025-02-11 17:00:36 +0100, Jelte Fennema-Nio wrote:
> On Tue, 11 Feb 2025 at 16:36, Andres Freund <andres@anarazel.de> wrote:
> > Shrug. It means that it'll not work in what I hope will be the default
> > mechanism before long.  I just can't get excited for that. In all likelihood
> > it'll result in bug reports that I'll then be on the hook to fix.
> 
> My assumption was that io_uring would become the default mechanism on
> Linux. And that bgworker based AIO would generally only be used by
> platforms without similar functionality. Is that assumption incorrect?

Yes, at least initially:
1) it's not enabled on the kernel level everywhere
2) it requires an optional build dependency
3) it requires tuning the file descriptor ulimit, unless we can convince Tom
   that it's ok to do that ourselves

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Ashutosh Sharma
Date:
Subject: Re: Orphaned users in PG16 and above can only be managed by Superusers
Next
From: Shlok Kyal
Date:
Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.