From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: david@lang.hm
To: Kevin Grittner <Kgrittn.CCAP.Courts@wicourts.gov>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jignesh K. Shah <J.K.Shah@sun.com>
Subject: Re: Proposal of tunable fix for scalability of 8.4
Date: Mon, 16 Mar 2009 11:53:39 -0500
Message-ID: <49BE3DC3.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <49BE2E80.EE98.0025.0@wicourts.gov>
References: <alpine.GSO.2.01.0903121613270.1925@westnet.com>
<C5DED7A7.33B2%scott@richrelevance.com>
<603c8f070903121829r31cf1472ha9876e5c480a542e@mail.gmail.com>
<603c8f070903121829r31cf1472ha9876e5c480a542e@mail.gmail.com>
<12292.1236964604@sss.pgh.pa.us>
<49BA5960.EE98.0025.0@wicourts.gov>
<alpine.DEB.1.10.0903132124470.6196@asgard>
<49BE2E80.EE98.0025.0@wicourts.gov>
I wrote:
> One more reason this point is an interesting one is that it is one
> that gets *worse* with the suggested patch, if only by half a
percent.
>
> Without:
>
> 600: 80: Medium Throughput: 82632.000 Avg Medium Resp: 0.005
>
> with:
>
> 600: 80: Medium Throughput: 82241.000 Avg Medium Resp: 0.005
Oops. A later version:
> Redid the test with - waking up all waiters irrespective of shared,
> exclusive
> 600: 80: Medium Throughput: 82920.000 Avg Medium Resp: 0.005
The one that showed the decreased performance at 800 was:
> a modified Fix (not the original one that I proposed but something
> that works like a heart valve : Opens and shuts to minimum
> default way thus controlling how many waiters are waked up )
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, david@lang.hm, Kgrittn.CCAP.Courts@wicourts.gov, robertmhaas@gmail.com, gsmith@gregsmith.com, scott@richrelevance.com, tgl@sss.pgh.pa.us, J.K.Shah@sun.com
Subject: Re: Proposal of tunable fix for scalability of 8.4
In-Reply-To: <49BE3DC3.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox