Re: Lowering the default wal_blocksize to 4K

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Lowering the default wal_blocksize to 4K
Дата
Msg-id 20231009233620.vkj3g6mxk3czg27g@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Lowering the default wal_blocksize to 4K  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Lowering the default wal_blocksize to 4K  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
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.

Greetings,

Andres Freund



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Lowering the default wal_blocksize to 4K
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Lowering the default wal_blocksize to 4K