Julien Rouhaud <rjuju...@gmail.com> writes: > Working on some side project that can cause dump of hash partitions to be > routed to a different partition, I realized that --load-via-partition-root can > indeed cause deadlock in such case without FK dependency or anything else.
> The problem is that each worker will perform a TRUNCATE TABLE ONLY followed by > a copy of the original partition's data in a transaction, and that obviously > will lead to deadlock if the original and locked partition and the restored > partition are different. Oh, interesting. I wonder if we can rearrange things to avoid that. regards, tom lane