| From: | Sean O'Grady <sean(at)thingee(dot)com> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "Wetmore, Matthew (CTR)" <matthew(dot)wetmore(at)express-scripts(dot)com> |
| Subject: | Re: Question about wal_compression and what to expect |
| Date: | 2023-06-21 14:04:28 |
| Message-ID: | 1c92a69086aa7046c2141a3849b1eff92eb68a37@hey.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
With archive_timeout set I think WAL files will often (at least in my
case) be created before they are filled, and in those cases there should
be a larger benefit, correct?
Thanks
On June 21, 2023, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
> > On Jun 21, 2023, at 7:51 AM, Sean O'Grady <sean(at)thingee(dot)com> wrote:
> >
> > Yes, my question was essentially do I need to separately compress
> WAL files for storage/archiving even with wal_compression set. So, I
> think you've answered my question.
>
> If WAL files use per-page compression internally, you won't get much
> benefit from compressing them. If they use lz4 internally, then sure,
> bzip'ing them will get a little benefit, but nowhere near the normal
> amount.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2023-06-21 14:06:11 | Re: Why do i need to install set_user extension if i can directly grant all required privileges to user? |
| Previous Message | Scott Ribe | 2023-06-21 13:55:33 | Re: Question about wal_compression and what to expect |