Oh, to be clear - I'll be implementing your suggestion regardless, it seems valuable whether or not it gets me closer to the root cause this time :)
I was just trying to dig into why it may be relevant -- I want to really get a good grip on the mechanism behind this phenomenon. Cheers Patrick On Fri, 7 Sep 2018, 20:20 Jeff Janes, <jeff.ja...@gmail.com> wrote: > On Fri, Sep 7, 2018 at 2:03 PM Patrick Molgaard <draag...@gmail.com> > wrote: > >> >> Hi Jeff, >> >> Thanks for your reply. Are locks relevant in this case, though? >> > > I don't know, but why theorize when we can know for sure? It at least > invokes VirtualXactLockTableInsert. I don't see how that could block on a > heavyweight lock, though. But again, why theorize when logging it is simple? > > Is it always the first statement in a connection which is blocking, or > will established connections also block at the same time the new ones start > to block? > > Cheers, > > Jeff > >>
