Re: RFC: Allow EXPLAIN to Output Page Fault Information

From: torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
To: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org, andres(at)anarazel(dot)de, tgl(at)sss(dot)pgh(dot)pa(dot)us, rjuju123(at)gmail(dot)com, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: RFC: Allow EXPLAIN to Output Page Fault Information
Date: 2026-01-28 14:59:20
Message-ID: ca6d2effbd47917ec37c836a47c54329@oss.nttdata.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2026-01-28 22:27, torikoshia wrote:
> On 2026-01-25 23:35, Jelte Fennema-Nio wrote:
>
>> On Tue Oct 28, 2025 at 9:43 AM CET, torikoshia wrote:
>>> Rebased the patch again.
>>
>> I took another look at this patch because I think it would be really
>> useful to have. Below is my review:
>
> Thank you for the review!
>
>> 8. Now that worker is the default io_method the new explain fields are
>> never
>> present in the explain tests anymore. So explain_1.out is
>> unnecessary and can be removed. That obviously also means that
>> there's no coverage for this feature at all in the tests currently,
>> which is clearly a problem. So I think it would be good to add some
>> actual tests for the feature using some other io_method in a Perl
>> TAP
>> test.
>
> However, I noticed that there are test environments where io_method is
> set to io_uring (for example, Linux Debian Trixie builds on Cirrus CI
> using Meson), so it appears that explain_1.out is still needed.
> Given this, adding the Perl TAP test might be somewhat redundant, but
> for now I’m attaching a patch that includes both.
>
>> 9. The added docs about the kernel not being built with the correct
>> options seems a bit too much detail. I'd say remove that sentence.
>> And maybe shorten th
>
> Is this comment still a work in progress?
>
> I agree with the other comments. Attached an updated patch reflecting
> them.

Updated the patch to fix a regression test failure.

>
>
> Regards,
>
> --
> Atsushi Torikoshi
> Seconded from NTT DATA Japan Corporation to SRA OSS K.K

Attachment Content-Type Size
v9-0001-Add-storage-I-O-tracking-to-BUFFERS-option.patch text/x-diff 74.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2026-01-28 15:00:45 Re: pgsql: Prevent invalidation of newly synced replication slots.
Previous Message Álvaro Herrera 2026-01-28 14:33:21 Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY