Re: Checkpointer write combining - Mailing list pgsql-hackers

On Wed, Jan 14, 2026 at 6:35 PM Melanie Plageman
<melanieplageman@gmail.com> wrote:
>
> Thanks! v13 attached.

I've added background writer write combining and then spent some time
refactoring and benchmarking this over the last few weeks, and I've
realized I won't be able to get it in shape for Postgres 19. I've
attached version 14 here with my WIP code so I can come back to it in
the next release.

0012 is an invasive refactor of GetVictimBuffer() and all the
functions it calls that needs to be split apart into smaller commits
and redistributed throughout the other patches in the set. Other than
that, there are a number of todos both in the code and from a
benchmarking perspective:

- Probe for preceding as well as following blocks when looking for
blocks to combine
- Experiment with different batch sizes
- Enable and test bulkread and vacuum write combining

I also periodically get this troubling warning: "WARNING:  invalid
page in block 2 of relation "base/16384/2608_fsm"; zeroing out page".
So clearly there's at least one bug somewhere.

FWIW benchmarks showed a large improvement from backend and bgwriter
write combining, but I'll provide more detailed output from benchmarks
when I post a more reviewable patch set.

0001 and 0002 are completely independent cleanup that should be pushed
anyway, so I might do that, but I didn't want to do so without having
posted on the list at least once.

- Melanie