public inbox for [email protected]
help / color / mirror / Atom feedFrom: Michael Paquier <[email protected]>
To: Andres Freund <[email protected]>
Cc: Andy Pogrebnoi <[email protected]>
Cc: [email protected]
Cc: Heikki Linnakangas <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: Thomas Munro <[email protected]>
Cc: Matthias van de Meent <[email protected]>
Subject: Re: Lowering the default wal_blocksize to 4K
Date: Tue, 17 Feb 2026 16:26:29 +0900
Message-ID: <[email protected]> (raw)
In-Reply-To: <x56pxq6jpuftn6ear3uwbz5tyb4r37itv5zetvcucq3td57apc@yq7jyka7tszv>
References: <[email protected]>
<[email protected]>
<x56pxq6jpuftn6ear3uwbz5tyb4r37itv5zetvcucq3td57apc@yq7jyka7tszv>
On Mon, Feb 16, 2026 at 04:13:37PM -0500, Andres Freund wrote:
> On 2026-02-16 10:04:37 +0200, Andy Pogrebnoi wrote:
>> 8Kb XLOG_BLCKSZ
>> ====
>> Threads tps kB_wrtn
>> 1 535.34 207288
>> 5 1457.24 591708
>> 10 1441.85 574700
>> 15 823.98 388732
>>
>> 4Kb XLOG_BLCKSZ
>> ====
>> Threads tps kB_wrtn
>> 1 542.02 153544
>> 5 1556.83 393444
>> 10 1288.00 339648
>> 15 975.32 255708
>
> The reduction in bytes written is rather impressive...
It's a pretty nice improvement for a change as simple as that, yes.
+1.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (833B, 2-signature.asc)
download
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Lowering the default wal_blocksize to 4K
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox