Re: WAL compression and replica

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: WAL compression and replica
Date: 2024-03-25 20:17:23
Message-ID: CAKFQuwYQX9bKp+4GDU+yzB_CkjHiAsft_Y9_Q7L1Q4+v8Ncs7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Mar 25, 2024 at 1:10 PM Scott Ribe <scott_ribe(at)elevated-dev(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2024-03-25 20:21:11 Re: WAL compression and replica
Previous Message Scott Ribe 2024-03-25 20:10:04 WAL compression and replica