Re: RFC: Allow EXPLAIN to Output Page Fault Information

From: Andres Freund <andres(at)anarazel(dot)de>
To: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>, pgsql-hackers(at)postgresql(dot)org, rjuju123(at)gmail(dot)com, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: RFC: Allow EXPLAIN to Output Page Fault Information
Date: 2025-02-11 16:19:14
Message-ID: zluvsuokej5tpqirkrmhwdikg5cwhkzu2dvlpkdizlukitu7vl@yaglatfcccho
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)anarazel(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shlok Kyal 2025-02-11 16:25:55 Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
Previous Message Ashutosh Sharma 2025-02-11 16:18:08 Re: Orphaned users in PG16 and above can only be managed by Superusers