On Mon, Mar 14, 2011 at 10:21:27PM +0100, Martijn van Oosterhout wrote: > On Mon, Mar 14, 2011 at 07:49:46PM +0100, hubert depesz lubaczewski wrote: > > These 60 were summarized, and output is available here: > > http://www.depesz.com/various/locks.summary.txt > > > > as you can seem, in 48 cases backend process was in semop(), which relates > > directly to my previous findings with ps/wchan. > > It's unfortunate you don't have debug symbols enabled, which makes > these traces somewhat unreliable. So you get odd things like index_open > calling index_close. That trace is legitimate. If index_open()'s call into the relcache needs to consult the catalogs, it will in turn scan pg_class_oid_index. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
