Re: Proposal of tunable fix for scalability of 8.4 - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Proposal of tunable fix for scalability of 8.4
Date
Msg-id 1237037402.3963.36.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Proposal of tunable fix for scalability of 8.4  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Responses Re: Proposal of tunable fix for scalability of 8.4  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
On Wed, 2009-03-11 at 16:53 -0400, Jignesh K. Shah wrote:

> 1200: 2000: Medium Throughput: -1781969.000 Avg Medium Resp: 0.019

I think you need to iron out bugs in your test script before we put too
much stock into the results generated. Your throughput should not be
negative.

I'd be interested in knowing the number of S and X locks requested, so
we can think about this from first principles. My understanding is that
ratio of S:X is about 10:1. Do you have more exact numbers?

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
Next
From: Tom Lane
Date:
Subject: Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4