Am 2015-05-04 18:19, schrieb Mel Llaguno:
My understanding of parallel dump performance is that it only makes a
difference when you have a large number of DBs (thousands if not tens
of
thousands). We performed similar testing using 9.3.x and found little
performance gains using -j (with 100+ tables). See Bruce Momjian’s
post :
http://momjian.us/main/blogs/pgblog/2012.html
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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
