Re: Map WAL segment files on PMEM as WAL buffers - Mailing list pgsql-hackers

From Takashi Menjo
Subject Re: Map WAL segment files on PMEM as WAL buffers
Date
Msg-id CAOwnP3PWp=bDp4CJoaNn6F9KoYKKZDWs88y9eThxS92PcZ4WpA@mail.gmail.com
Whole thread Raw
In response to Map WAL segment files on PMEM as WAL buffers  (Takashi Menjo <takashi.menjo@gmail.com>)
Responses Re: Map WAL segment files on PMEM as WAL buffers
List pgsql-hackers
Hi hackers,

The v2 patchset, an updated performance report, and a zipped
supplemental patchset for comparison in the report. I confirmed that
the v2 can be applied to the latest master d24c565 (Jun 17 2021)
without conflict, but the supplemental patchset cannot. If you want to
reproduce the comparison, please apply to eb43bdb (May 25, 2021) as I
did so in the report.

The v2 includes WAL statistics support and WAL pre-allocation feature
in cases of PMEM, and some fixes for the first version. The size of
WAL buffers managed by xlblocks becomes min_wal_size, and the buffers
and underlying segment files are initialized at startup then
periodically by walwriter. This looks to improve performance, as I
wrote in the report.

By the way, I found that Nathan-san posted a PoC patch for WAL
pre-allocation in another thread [1]. I will pay attention to it and
discussions related to WAL pre-allocation in pgsql-hackers.

Best regards,
Takashi

[1] https://www.postgresql.org/message-id/flat/20201225200953.jjkrytlrzojbndh5%40alap3.anarazel.de

-- 
Takashi Menjo <takashi.menjo@gmail.com>

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Toast compression method options
Next
From: Michael Paquier
Date:
Subject: Re: Refactor ECPGconnect and allow IPv6 connection