Re: Lowering the default wal_blocksize to 4K
От
Bruce Momjian
Тема
Re: Lowering the default wal_blocksize to 4K
Дата
Msg-id
ZSSQjIYdjFxw_dp9@momjian.us
Ответ на
Re: Lowering the default wal_blocksize to 4K (Andres Freund)
Список
Дерево обсуждения
Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Tom Lane <tgl@sss.pgh.pa.us>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Thomas Munro <thomas.munro@gmail.com>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Robert Haas <robertmhaas@gmail.com>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Robert Haas <robertmhaas@gmail.com>
Re: Lowering the default wal_blocksize to 4K Thomas Munro <thomas.munro@gmail.com>
Re: Lowering the default wal_blocksize to 4K Thomas Munro <thomas.munro@gmail.com>
Re: Lowering the default wal_blocksize to 4K Robert Haas <robertmhaas@gmail.com>
Re: Lowering the default wal_blocksize to 4K Ants Aasma <ants@cybertec.at>
Re: Lowering the default wal_blocksize to 4K Robert Haas <robertmhaas@gmail.com>
Re: Lowering the default wal_blocksize to 4K Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: Lowering the default wal_blocksize to 4K Andy Pogrebnoi <andrew.pogrebnoi@percona.com>
Re: Lowering the default wal_blocksize to 4K Andy Pogrebnoi <andrew.pogrebnoi@percona.com>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Michael Paquier <michael@paquier.xyz>
Re: Lowering the default wal_blocksize to 4K Andrew Pogrebnoi <andrew.pogrebnoi@percona.com>
Re: Lowering the default wal_blocksize to 4K Andy Pogrebnoi <andrew.pogrebnoi@percona.com>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K John Naylor <johncnaylorls@gmail.com>
Re: Lowering the default wal_blocksize to 4K Bruce Momjian <bruce@momjian.us>
Re: Lowering the default wal_blocksize to 4K Andres Freund <andres@anarazel.de>
Re: Lowering the default wal_blocksize to 4K Bruce Momjian <bruce@momjian.us>
On Mon, Oct 9, 2023 at 04:36:20PM -0700, Andres Freund wrote: > Hi, > > On 2023-10-09 19:26:54 -0400, Bruce Momjian wrote: > > On Mon, Oct 9, 2023 at 04:08:05PM -0700, Andres Freund wrote: > > > There's an alternative approach we could take, which is to write in 4KB > > > increments, while keeping 8KB pages. With the current format that's not > > > obviously a bad idea. But given there aren't really advantages in 8KB WAL > > > pages, it seems we should just go for 4KB? > > > > How do we handle shorter maximum row lengths and shorter maximum index > > entry lengths? > > The WAL blocksize shouldn't influence either, unless we have a bug somewhere. Oh, good point. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
В списке pgsql-hackers по дате отправления