Re: Proposal of tunable fix for scalability of 8.4

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Proposal of tunable fix for scalability of 8.4
Date: 2009-03-14 13:30:02
Message-ID: 1237037402.3963.36.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message decibel 2009-03-14 14:31:31 Re: Query much slower when run from postgres function
Previous Message Heikki Linnakangas 2009-03-14 08:23:57 Re: Proposal of tunable fix for scalability of 8.4