Re: WAL compression and replica

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Mar 25, 2024, at 2:17 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
> 
> On Mon, Mar 25, 2024 at 1:10 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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.

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







[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux