Postgres Pro
Downloads
Home   >   mailing lists

pg_restore parallel from machine with more CPUs than the server... bad? - Mailing list pgsql-admin

From Wells Oliver
Subject pg_restore parallel from machine with more CPUs than the server... bad?
Date
Msg-id CAOC+FBX2bDfuf5bm0=+81ij9yeJMNh+tESREm_Bv6sqpFYbvZA@mail.gmail.com
Whole thread Raw
Responses Re: pg_restore parallel from machine with more CPUs than the server... bad?
List pgsql-admin
Tree view
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 by date:

Previous
From: Wells Oliver
Date:
Subject: Re: pg_restore: warning: invalid creation date in header
Next
From: Vijaykumar Jain
Date:
Subject: Re: pg_restore parallel from machine with more CPUs than the server... bad?