>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> and changing the buf_table hash table. The only common Tom> operation that needs exclusive lock is reading in a page that Tom> was not in shared buffers already, which will require at Tom> least a kernel call and usually a wait for I/O, so it will be Tom> slow anyway. Why not a separate lock per bucket chain in the hash table in addition to the system-wide LWLock ? It's not so much that such an operation will be slow anyway but that such a slow operation will unnecessarily block other operations. -- Pip-pip Sailesh http://www.cs.berkeley.edu/~sailesh ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings