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)?