Re: WAL compression and replica

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: WAL compression and replica
Дата
Msg-id 9435FDA8-261B-4E05-976C-6BB1EBC81815@elevated-dev.com
обсуждение исходный текст
Ответ на Re: WAL compression and replica  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
> On Mar 25, 2024, at 2:17 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> 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
otherwords, 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
abase backup. 
>
> That is, some of the contents are compressed, it is not the container that gets compressed.  That is always 64MB in a
defaultcompilation. 
>
> David J.

I read that last week, and totally missed the implication. Thanks.




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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: WAL compression and replica
Следующее
От: Uzair Khan
Дата:
Сообщение: Subject: Assistance Required: Adding Multiple Libraries to shared_preload_libraries in postgresql.conf