| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Andy Pogrebnoi <andrew(dot)pogrebnoi(at)percona(dot)com>, pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
| Subject: | Re: Lowering the default wal_blocksize to 4K |
| Date: | 2026-02-17 07:26:29 |
| Message-ID: | aZQYJcRAunlZLDZY@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2026-02-17 07:44:39 | Re: Consider low startup cost in add_partial_path |
| Previous Message | Nazir Bilal Yavuz | 2026-02-17 07:21:06 | Re: Improve docs syntax checking and enable it in the meson build |