Tom Lane wrote:

It could be that I'm all wet and there is no relationship between the
cache line thrashing and the seemingly excessive BufMgrLock contention.

Is it important? The fix is identical in both cases: per-bucket locks for the hash table and a buffer aging strategy that doesn't need one global lock that must be acquired for every lookup.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to