pgsql: Reduce the default size of the local lock hash table. - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Reduce the default size of the local lock hash table.
Date
Msg-id 20041120201656.453A13A4DD7@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Reduce the default size of the local lock hash table.  There's usually
no need for it to be nearly as big as the global hash table, and since
it's not in shared memory it can grow if it does need to be bigger.
By reducing the size, we speed up hash_seq_search(), which saves a
significant fraction of subtransaction entry/exit overhead.

Modified Files:
--------------
    pgsql/src/backend/storage/lmgr:
        lock.c (r1.143 -> r1.144)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/storage/lmgr/lock.c.diff?r1=1.143&r2=1.144)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix plperl's elog() function to convert elog(ERROR) into Perl
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Avoid scanning the relcache during AtEOSubXact_RelationCache when