Request a Demo
Home   >   mailing lists

Re: Does pg_dump custom format only compress the table data? - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Does pg_dump custom format only compress the table data?
Date
Msg-id CANzqJaA=e+OgRHtD_W2Ht6ZOu+GY+FZHfLtKWOrGqgkmvVMCpA@mail.gmail.com
Whole thread
In response to Re: Does pg_dump custom format only compress the table data?  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
On Tue, Feb 3, 2026 at 2:51 AM Holger Jakobs <holger@jakobs.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!

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Does pg_dump custom format only compress the table data?
Next
From: Laurenz Albe
Date:
Subject: Re: Does pg_dump custom format only compress the table data?