• Heikki Linnakangas's avatar
    Reduce the initial size of local lock hash to 16 entries. · 4c37c1e3
    Heikki Linnakangas authored
    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.
    4c37c1e3
lock.c 79.6 KB