Re: Pre-allocating WAL files - Mailing list pgsql-hackers

From Bossart, Nathan
Subject Re: Pre-allocating WAL files
Date
Msg-id CB15BEBD-98FC-4E72-86AE-513D34014176@amazon.com
Whole thread Raw
In response to Re: Pre-allocating WAL files  (Maxim Orlov <m.orlov@postgrespro.ru>)
Responses Re: Pre-allocating WAL files
Re: Pre-allocating WAL files
List pgsql-hackers
On 10/8/21, 1:55 PM, "Bossart, Nathan" <bossartn@amazon.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


Attachment

pgsql-hackers by date:

Previous
From: "Bossart, Nathan"
Date:
Subject: Re: archive modules
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: 2021-11-11 release announcement draft