Re: Lock partitions

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
>> I see this in the CVS commits for 8.2.  Did we determine the proper
>> number of lock partitions?  Should it be based on the number of buffers
>> or concurrent sessions allowed?
> 
> No.  NUM_LOCK_PARTITIONS needs to be a compile-time constant for a
> number of reasons, and there is absolutely zero evidence to justify
> making any effort (and spending any cycles) on a variable value.
> 
> It would be nice to see some results from the OSDL tests with, say, 4,
> 8, and 16 lock partitions before we forget about the point though.
> Anybody know whether OSDL is in a position to run tests for us?

Yeah, I can run some dbt2 tests in the lab.  I'll get started on it. 
We're still a little bit away from getting the automated testing for 
PostgreSQL going again though.

Mark