Re: Lock partitions - Mailing list pgsql-hackers

From Mark Wong
Subject Re: Lock partitions
Date
Msg-id 45057EC3.7000909@osdl.org
Whole thread Raw
In response to Re: Lock partitions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: contrib/xml2 and PG_MODULE_MAGIC
Next
From: Simon Riggs
Date:
Subject: Re: Fixed length data types issue