There may be a bug so perhaps still pursue reproducing the issue, but I would expect drop concurrently to resolve your issue with the two processes conflicting. Also, perhaps trying"insert, on conflict do update" could be more efficient than the copy but obviously there are too many unknowns and variables for either to be a definite winner.
- Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Rob Sargent
- Re: Undetected Deadlock Alvaro Herrera
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Michael Lewis
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Michael Lewis
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Simon Riggs
- Re: Undetected Deadlock Tom Lane
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Tom Lane
- Re: Undetected Deadlock Michael Harris
- Re: Undetected Deadlock Tom Lane
- Re: Undetected Deadlock Simon Riggs