"Thomas F. O'Connell" <tfo@xxxxxxxxxxxx> writes: > For instance, if a long SELECT were running against table_foo and an > UPDATE arrived wanting to update table_foo, I would expect to see in > pg_locks an entry corresponding to the SELECT with granted = true and > an entry corresponding to the UPDATE with granted = false. Why would you expect to see that exactly? SELECTs don't block UPDATEs. regards, tom lane
