Re: parallel restore sometimes fails for FKs to partitioned tables

2019-10-17 Thread Alvaro Herrera
On 2019-Oct-05, Alvaro Herrera wrote: > While playing around I noticed that depending on the number of parallel > workers in pg_restore compared to the number of partitions a table has, > restoring an FK fails because the FK itself is restored before the index > partitions have completed restoring

parallel restore sometimes fails for FKs to partitioned tables

2019-10-06 Thread Alvaro Herrera
Hello While playing around I noticed that depending on the number of parallel workers in pg_restore compared to the number of partitions a table has, restoring an FK fails because the FK itself is restored before the index partitions have completed restoring. The exact conditions to cause the fai