2015-10-15 23:05 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> On 10/15/2015 01:35 PM, anj patnaik wrote: > >> Hello all, >> I will experiment with -Fc (custom). The file is already growing very >> large. >> >> I am running this: >> ./pg_dump -t RECORDER -Fc postgres | gzip > /tmp/dump >> >> Are there any other options for large tables to run faster and occupy >> less disk space? >> > > Yes, do not double compress. -Fc already compresses the file. > > Right. But I'd say "use custom format but do not compress with pg_dump". Use the -Z0 option to disable compression, and use an external multi-threaded tool such as pigz or pbzip2 to get faster and better compression. -- Guillaume. http://blog.guillaume.lelarge.info http://www.dalibo.com
