From: | Michael Heaney <mheaney(at)jcvi(dot)org> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump with custom format without compression |
Date: | 2017-04-08 10:22:38 |
Message-ID: | 226e4bc5-8f3d-44d1-1c06-41c90056f5c5@jcvi.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 4/8/2017 4:58 AM, Thorsten Schöning wrote:
> Hi all,
>
> I'm using pg_dump with custom format "c" on some databases containing
> already compressed large binaries, like Zip, compressed PDF etc. So I
> don't benefit of the compression of format "c" much, but creating a
> dump takes about twice as much time compared to uncompressed format
> "t".
>
> Is there any way to use format "c" without any compression, so I get
> somewhat the same processing time like with format "t"?
>
> From the docs it sounds that format "c" is the most flexible when it
> comes to restore and I would simply like to keep all the options it
> provides, just in case. So if not compression is only possible with
> "t", I might as well decide to use that and live with its theoretical
> shortcomings on restore.
>
> Thanks!
>
> Mit freundlichen Grüßen,
>
> Thorsten Schöning
>
Try setting the compression level. I myself use "--compress=1", which
gives me decent compression for very little cost in backup speed.
--
Michael Heaney
JCVI
From | Date | Subject | |
---|---|---|---|
Next Message | Thorsten Schöning | 2017-04-08 11:31:18 | Re: pg_dump with custom format without compression |
Previous Message | Thorsten Schöning | 2017-04-08 08:58:02 | pg_dump with custom format without compression |