Request a Demo
Home   >   mailing lists

Re: Lowering the default wal_blocksize to 4K - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Lowering the default wal_blocksize to 4K
Date
Msg-id aZQYJcRAunlZLDZY@paquier.xyz
Whole thread Raw
In response to Re: Lowering the default wal_blocksize to 4K  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: Improve docs syntax checking and enable it in the meson build
Next
From: Richard Guo
Date:
Subject: Re: Consider low startup cost in add_partial_path