Re: [HACKERS] AdvanceXLInsertBuffer vs. WAL segment compressibility

Chapman Flack <chap@anastigmatix.net>

From: Chapman Flack <chap@anastigmatix.net>

To: Daniel Gustafsson <daniel@yesql.se>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Michael Paquier <michael.paquier@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>, Robert Haas <robertmhaas@gmail.com>, Bruce Momjian <bruce@momjian.us>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2018-03-19T00:06:41Z

Lists: pgsql-hackers

Attachments

0002-Add-test-for-ensuring-WAL-segment-is-zeroed-out.patch (text/x-patch)

On 03/18/18 19:28, Daniel Gustafsson wrote:
> It seems expensive to regex over BLCKSZ, but it’s probably the safest option
> and it’s not a performance critical codepath.  Feel free to whack the test
> patch over the head with the above diff.

Both patches in a single email for cfbot's enjoyment, coming right up.

-Chap

Commits

Ensure that WAL pages skipped by a forced WAL switch are zero-filled.
- 4a33bb59dfc3 11.0 landed
Improve scalability of WAL insertions.
- 9a20a9b21baa 9.4.0 cited
Move BKP_REMOVABLE bit from individual WAL records to WAL page headers.
- 2dd9322ba6ee 9.2.0 cited