| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Does pg_dump custom format only compress the table data? |
| Date: | 2026-02-03 08:13:37 |
| Message-ID: | CANzqJaA=e+OgRHtD_W2Ht6ZOu+GY+FZHfLtKWOrGqgkmvVMCpA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tue, Feb 3, 2026 at 2:51 AM Holger Jakobs <holger(at)jakobs(dot)com> wrote:
> Am 03.02.26 um 07:06 schrieb Laurenz Albe:
> > On Mon, 2026-02-02 at 10:55 -0500, Ron Johnson wrote:
> >> Out of curiosity, I opened that dump file in vim, and saw not only DDL
> strings but cleartext table data.
> >>
> >> Why isn't it compressed?
> > Are your DDL statement large enough that you would expect that
> compressing
> > them would offer any real advantage?
> >
> > Yours,
> > Laurenz Albe
>
> That wasn't the question. It was about why table DATA aren't compressed,
> but in clear text.
>
Exactly. Does the compression algorithm have some sort of threshold under
which it ignores the --compress switch?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2026-02-03 12:47:49 | Re: Does pg_dump custom format only compress the table data? |
| Previous Message | Holger Jakobs | 2026-02-03 07:51:11 | Re: Does pg_dump custom format only compress the table data? |