Mike Roest <mike.roest@xxxxxxxxxxxx> writes: > This dump is currently taking around 8 minutes. While dumping the pg_dump > process is using 100% of one core in the server (24 core machine). Doing a > -v pg_dump I found that the following stages are taking the majority of the > time > reading user_defined tables (2 minutes and 20 seconds) > reading dependency data (5 minutes and 30 seconds) Can you get an execution profile with oprofile or gprof or similar tool? It doesn't surprise me a lot that pg_dump might have some issues with large numbers of objects, but guessing which inefficiencies are hurting you is difficult without more info. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
