Re: Lowering the default wal_blocksize to 4K

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lowering the default wal_blocksize to 4K
Дата
Msg-id 240625.1696907790@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> 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?

Seems like that's doubling the overhead of WAL page headers.  Do we need
to try to skinny those down?

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag
Следующее
От: Peter Smith
Дата:
Сообщение: Re: PGDOCS - add more links in the pub/sub reference pages