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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
