Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: Multi-second pauses blocking even trivial activity
Date
Msg-id CAMkU=1zQzSpFvWXaJ9xP1dsO9S0K7mPKAf61hniGyumKfdshrQ@mail.gmail.com
Whole thread Raw
In response to Re: Multi-second pauses blocking even trivial activity  (Patrick Molgaard <draaglom@gmail.com>)
Responses Re: Multi-second pauses blocking even trivial activity
List pgsql-performance
Tree view
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: "Joshua D. Drake"
Date:
Subject: Re: Multi-second pauses blocking even trivial activity
Next
From: Tim Cross
Date:
Subject: Re: Performance of INSERT into temporary tables using psqlODBC driver