pg_restore parallel from machine with more CPUs than the server... bad?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема pg_restore parallel from machine with more CPUs than the server... bad?
Дата
Msg-id CAOC+FBX2bDfuf5bm0=+81ij9yeJMNh+tESREm_Bv6sqpFYbvZA@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_restore parallel from machine with more CPUs than the server... bad?  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список pgsql-admin
Дерево обсуждения
I have an AWS RDS instance with 4 CPU. I have a EC2 instance I fired up with 16 CPU thinking I could pg_restore --jobs 16 and it would be great, and my restore ground to a halt with a bunch of locks on refreshing materializing views about 600GB into ~700GB.

I was wondering if there was any risk associated with restoring on a computer with more CPU than the destination server (and indeed using more CPU than the server)?


--

В списке pgsql-admin по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: pg_restore: warning: invalid creation date in header
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: pg_restore parallel from machine with more CPUs than the server... bad?