Re: Lock partitions - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Lock partitions
Date
Msg-id 1158050202.2692.444.camel@holly
Whole thread Raw
In response to Re: Lock partitions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Lock partitions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Lock partitions  ("Strong, David" <david.strong@unisys.com>)
List pgsql-hackers
On Mon, 2006-09-11 at 11:29 -0400, Tom Lane wrote:
> Mark Wong <markw@osdl.org> writes:
> > Tom Lane wrote:
> >> 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.
> 
> Great, thanks.  The thing to twiddle is LOG2_NUM_LOCK_PARTITIONS in
> src/include/storage/lwlock.h.  You need a full backend recompile
> after changing it, but you shouldn't need to initdb, if that helps.

IIRC we did that already and the answer was 16...

--  Simon Riggs              EnterpriseDB   http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: [PATCHES] Fix linking of OpenLDAP libraries
Next
From: Simon Riggs
Date:
Subject: Re: Optimizer improvements: to do or not to do?