On Mon, Nov 29, 2010 at 03:57:29PM -0500, Vick Khera wrote: > On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > hubert depesz lubaczewski <depesz@xxxxxxxxxx> 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. jkust so it will be clear - on some other occasion when we had the problem, i left it hng for a while. 5 minutes later i still didn't get the connection. Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@xxxxxxxxxx / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
