Re: Multi-second pauses blocking even trivial activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux