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.
I'd certainly never go beyond $(nproc), but since COPY generates a lot of IO and compression burns through CPU, it all depends on the system's other workload. Only you know what your system's other workload is when pg_dump is running.
Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.