Re: Lock partitions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Lock partitions
Date
Msg-id 5772.1157934630@sss.pgh.pa.us
Whole thread Raw
In response to Lock partitions  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Lock partitions
Re: Lock partitions
List pgsql-hackers
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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: contrib uninstall scripts need some love
Next
From: Kevin Brown
Date:
Subject: Re: Foreign keys