Docs on this setting describe it thus:
Sets the number of hash buckets in the per-user locking table. Adjust this based on the number of concurrent locks a user may hold.
and
The number of hash buckets for the per-process locking table.
This parameter is highly application dependent, If the application requires a large number of locks in one transaction (more than 20), you should increase this setting to the closest prime number to the maximum number of locks per transaction.
So if we have identified our maximum locks per transaction is a rather large number, like 5000, then this calculation would derive to 4999.
That does not seem to make sense.
Is there any real-world feedback on this?
