]> granicus.if.org Git - postgresql/commit
Reduce the initial size of local lock hash to 16 entries.
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Fri, 15 Apr 2011 11:57:51 +0000 (14:57 +0300)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Fri, 15 Apr 2011 12:07:36 +0000 (15:07 +0300)
commit4c37c1e3b2a7ba7b5519e5e366720e7444878a78
tree39527062f901800f66e70caf0d3daf3048c1d86a
parentf536d4194293f900577c728bfa4e62075a4c7da0
Reduce the initial size of local lock hash to 16 entries.

The hash table is seq scanned at transaction end, to release all locks,
and making the hash table larger than necessary makes that slower. With
very simple queries, that overhead can amount to a few percent of the total
CPU time used.

At the moment, backend startup needs 6 locks, and a simple query with one
table and index needs 3 locks. 16 is enough for even quite complicated
transactions, and it will grow automatically if it fills up.
src/backend/storage/lmgr/lock.c