Would someone be able to advise on the correct setting for the -j option of pg_dump to run the dump in parallel, please? Is it based on CPU count, or something else? The output of nproc is 32.
Thank you,
Sam
--
Samuel Stearns Team Lead - Database c: 971 762 6879 | o: 971 762 6879 | DAT.com