Postgres Pro
Downloads
Home   >   mailing lists

Re: Multi-second pauses blocking even trivial activity - Mailing list pgsql-performance

From Patrick Molgaard
Subject Re: Multi-second pauses blocking even trivial activity
Date
Msg-id CA+Zan4vZRReeE0TP3nMBNZxe5DogZFXAeJStAZLw2RbE2B4WDQ@mail.gmail.com
Whole thread Raw
In response to Re: Multi-second pauses blocking even trivial activity  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view
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@gmail.com> wrote:
On Fri, Sep 7, 2018 at 2:03 PM Patrick Molgaard <draaglom@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

pgsql-performance by date:

Previous
From: Tim Cross
Date:
Subject: Re: Performance of INSERT into temporary tables using psqlODBC driver
Next
From: Patrick Molgaard
Date:
Subject: Re: Multi-second pauses blocking even trivial activity