Tom Lane wrote:
Mark Wong <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Hmm, what sort of errors are we talking about?
ERROR: too many LWLocks taken
That really shouldn't happen ... are you sure you did a full recompile
after changing NUM_LOCK_PARTITIONS?
Actually ... wait a moment. The default value of NUM_LOCK_PARTITIONS
is already 16 (1 << LOG2_NUM_LOCK_PARTITIONS where the latter is 4).
Are you saying you set LOG2_NUM_LOCK_PARTITIONS to 16? That would be
way too many partitions. I was thinking of testing
LOG2_NUM_LOCK_PARTITIONS in the range of about 2 to 5.
Oops, I can't read bit shifting. =p I'll do again.
Mark
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
