Re: Multi-second pauses blocking even trivial activity

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: draaglom(at)gmail(dot)com
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Multi-second pauses blocking even trivial activity
Date: 2018-09-07 19:20:04
Message-ID: CAMkU=1zQzSpFvWXaJ9xP1dsO9S0K7mPKAf61hniGyumKfdshrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tim Cross 2018-09-08 00:05:10 Re: Performance of INSERT into temporary tables using psqlODBC driver
Previous Message Joshua D. Drake 2018-09-07 18:22:52 Re: Multi-second pauses blocking even trivial activity