Re: Lock partitions - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Lock partitions
Date
Msg-id 77177806-645E-4AAE-901E-8F6A64BC78D0@nasby.net
Whole thread Raw
In response to Re: Lock partitions  ("Strong, David" <david.strong@unisys.com>)
Responses Re: Lock partitions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sep 13, 2006, at 2:46 PM, Strong, David wrote:
> We have some results for you. We left the buffer partition locks at  
> 128
> as this did not seem to be a concern and we're still using 25 backend
> processes. We ran tests for 4, 8 and 16 lock partitions.

Isn't having more lock partitions than buffer partitions pointless?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lock partitions
Next
From: Tom Lane
Date:
Subject: Re: - Proposal for repreparing prepared statements