pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedWAL compression and replica
3+ messages / 2 participants
[nested] [flat]
* WAL compression and replica
@ 2024-03-25 20:10 Scott Ribe <scott_ribe@elevated-dev.com>
2024-03-25 20:17 ` Re: WAL compression and replica David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Scott Ribe @ 2024-03-25 20:10 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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?)
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL compression and replica
2024-03-25 20:10 WAL compression and replica Scott Ribe <scott_ribe@elevated-dev.com>
@ 2024-03-25 20:17 ` David G. Johnston <david.g.johnston@gmail.com>
2024-03-25 20:21 ` Re: WAL compression and replica Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2024-03-25 20:17 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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?)
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: WAL compression and replica
2024-03-25 20:10 WAL compression and replica Scott Ribe <scott_ribe@elevated-dev.com>
2024-03-25 20:17 ` Re: WAL compression and replica David G. Johnston <david.g.johnston@gmail.com>
@ 2024-03-25 20:21 ` Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 3+ messages in thread
From: Scott Ribe @ 2024-03-25 20:21 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> 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 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-03-25 20:21 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-03-25 20:10 WAL compression and replica Scott Ribe <scott_ribe@elevated-dev.com>
2024-03-25 20:17 ` David G. Johnston <david.g.johnston@gmail.com>
2024-03-25 20:21 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox