Re: "stuck spinlock" - Mailing list pgsql-hackers

From Christophe Pettus
Subject Re: "stuck spinlock"
Date
Msg-id 9C6D2D97-0161-40E5-BF21-53C623C941AB@thebuild.com
Whole thread Raw
In response to Re: "stuck spinlock"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "stuck spinlock"
List pgsql-hackers
On Dec 12, 2013, at 5:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Presumably, we are seeing the victim rather than the perpetrator of
> whatever is going wrong.

This is probing about a bit blindly, but the only thing I can see about this system that is in some way unique (and
thisis happening on multiple machines, so it's unlikely to be hardware) is that there are a relatively large number of
relations(like, 440,000+) distributed over many schemas.  Is there anything that pins a buffer that is O(N) to the
numberof relations? 

--
-- Christophe Pettus  xof@thebuild.com




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "stuck spinlock"
Next
From: Tom Lane
Date:
Subject: Re: "stuck spinlock"