Re: Multi-second pauses blocking even trivial activity

[Patrick Molgaard <draaglom@xxxxxxxxx>]

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.janes@xxxxxxxxx> wrote:

On Fri, Sep 7, 2018 at 2:03 PM Patrick Molgaard <draaglom@xxxxxxxxx> 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