Re: Pre-allocating WAL files

On 10/8/21, 1:55 PM, "Bossart, Nathan" <bossartn(at)amazon(dot)com> wrote:
> Here is a first attempt at adding the pre-allocation logic to the
> checkpointer. I went ahead and just used CheckpointWriteDelay() for
> pre-allocating during checkpoints. I've done a few pgbench runs, and
> it seems to work pretty well. Initialization is around 15% faster,
> and I'm seeing about a 5% increase in TPS with a simple-update
> workload with wal_recycle turned off. Of course, these improvements
> go away once segments can be recycled.

Here is a rebased version of this patch set. I'm getting the sense
that there isn't a whole lot of interest in this feature, so I'll
likely withdraw it if it goes too much longer without traction.

Nathan