Re: Lowering the default wal_blocksize to 4K

From: Andy Pogrebnoi <andrew(dot)pogrebnoi(at)percona(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: 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-16 08:19:21
Message-ID: 946FC143-9431-4C95-84D6-A6046A93C093@percona.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Feb 16, 2026, at 10:04, Andy Pogrebnoi <andrew(dot)pogrebnoi(at)percona(dot)com> wrote:
>
> Hello,
>
>
>> On Oct 10, 2023, at 02:08, Andres Freund <andres(at)anarazel(dot)de> wrote:
>>
>> Hi,
>>
>> I've mentioned this to a few people before, but forgot to start an actual
>> thread. So here we go:
>>
>> I think we should lower the default wal_blocksize / XLOG_BLCKSZ to 4096, from
>> the current 8192.
>
> I prepared a patch in case we want to move with the default 4kb XLOG_BLCKSZ.

I forgot to include the patch in the prev message

—
Cheers,
Andy

Attachment Content-Type Size
0001-Change-wal_blocksize-default-to-4KB.patch application/octet-stream 4.5 KB
unknown_filename text/plain 2 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hunaid Sohail 2026-02-16 08:20:58 Re: Proposal: SELECT * EXCLUDE (...) command
Previous Message Andy Pogrebnoi 2026-02-16 08:04:37 Re: Lowering the default wal_blocksize to 4K