On Wed, Nov 7, 2018 at 5:46 PM Peter Geoghegan <p...@bowt.ie> wrote: > I think that you have to be doing a multi-level delete for a deadlock > to take place, which isn't particularly likely to coincide with a > concurrent insertion in general. That may explain why it's taken a > year to get a high-quality bug report.
BTW, it's notable that Chen's query uses ON CONFLICT DO UPDATE. Speculative insertion might cause just the wrong kind of churn, involving continual recycling of heap TIDs. -- Peter Geoghegan
