-----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Jan Lentfer Sent: Monday, May 04, 2015 12:42 PM To: Mel Llaguno Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times I don't know about parallel pg_dump as we use -Fc and pg_dump can't do that in parallel (afaik). For dumping I have wrapped pg_dump in a shell script to dump several databases in parallel. But for pg_restore -j option does make a big difference, at least when you have a lot of larger tables and indexes. Regards, Jan Combination of -Fc and -j definitely works in pg_dump. And there is nothing in the docs that states otherwise. Regards, Igor Neyman -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
