On Nov 29, 2010, at 12:57 PM, Vick Khera wrote:
> On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
>> hubert depesz lubaczewski <
depesz@depesz.com> writes:
>>> straced postmaster when the problem was happening, and I was opening new
>>> connections. strace looks like this:
>>> [ backend hangs on semop immediately after reading global/pg_database ]
>>
>> It looks like something had exclusive lock on the database that new
>> connections wanted to connect to. AFAICS the only action in 8.3 that
>> would do that would be a DROP DATABASE or RENAME DATABASE. What was
>> that other session doing?
>
> Every once in a while when I connect to my big DB it feels like it
> stalls the connection for a few seconds. I have no idea what causes
> it, but it does feel like it has to do with the load. The load is not
> all that high relative to what my box can handle. It doesn't happen
> often enough for me to track it down, though. It instinct is that it
> is waiting on a lock, but clearly there is no rename/drop happening on
> my main db else i'd be out of business :-) I too run 8.3 as primary
> right now... testing 9.0 for deployment soon-ish.