On Fri, 15 Jan 2010, Tom Lane wrote:
#0 0x00007f59a5d78ca7 in semop () from /lib/libc.so.6
#1 0x0000000000546656 in PGSemaphoreLock ()
#2 0x00000000005618ee in LockBufferForCleanup ()
#3 0x000000000045c8e2 in btbulkdelete ()
OK, so it's trying to get an exclusive page-level lock on some page of
the index. The only thing that could block that for any long period is
if some other process is sitting with an open indexscan. Look around
for processes that have been "idle in transaction" for a long time ...
There are some, but they've all been running less than a second. There's
no better place to look than pg_stat_activity, is there?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
