Re: WAL compression and replica

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: WAL compression and replica
Дата
Msg-id CAKFQuwYQX9bKp+4GDU+yzB_CkjHiAsft_Y9_Q7L1Q4+v8Ncs7g@mail.gmail.com
обсуждение исходный текст
Ответ на WAL compression and replica  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: WAL compression and replica  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
On Mon, Mar 25, 2024 at 1:10 PM Scott Ribe <scott_ribe@elevated-dev.com> wrote:
If WAL compression is enabled, does this mean that traffic to a file-based WAL-shipping standby is compressed? (In other words, WAL files are sent post-compression?)

From the docs:
When enabled, the PostgreSQL server compresses full page images written to WAL when full_page_writes is on or during a base backup.

That is, some of the contents are compressed, it is not the container that gets compressed.  That is always 64MB in a default compilation.

David J.


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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: WAL compression and replica
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: WAL compression and replica