>>>>> "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

Reply via email to