Re: Multi-second pauses blocking even trivial activity

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(dot)janes(at)gmail(dot)com> wrote:

> On Fri, Sep 7, 2018 at 2:03 PM Patrick Molgaard <draaglom(at)gmail(dot)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
>
>>