On Thu, Jan 8, 2015 at 12:12 AM, Adalkonda Harshad [via PostgreSQL] <[hidden email]> wrote:
As the database size is too large and tweaking few database parameters will result towards performance improvement on pg_dump to some extent and pg_dump -j option would have helped if the DB version is PostgreSQL 9.3 but unfortunately your DB version is PostgreSQL 9.2
pg_dump 9.3+ can be used against the 9.2 server without problems. Read the documentation for the --jobs option for details.
