Re: Admission Control - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Admission Control
Date
Msg-id AANLkTikjXl3YnBVW7mJiZ-kf5hdQewJxAzSsCc0T4gXR@mail.gmail.com
Whole thread Raw
In response to Re: Admission Control  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: Admission Control
List pgsql-hackers
On Thu, Jul 8, 2010 at 10:21 PM, Mark Kirkwood
<mark.kirkwood@catalyst.net.nz> wrote:
> Purely out of interest, since the old repo is still there, I had a quick
> look at measuring the overhead, using 8.4's pgbench to run two custom
> scripts: one consisting of a single 'SELECT 1', the other having 100 'SELECT
> 1' - the latter being probably the worst case scenario. Running 1,2,4,8
> clients and 1000-10000 tramsactions gives an overhead in the 5-8% range [1]
> (i.e transactions/s decrease by this amount with the scheduler turned on
> [2]). While a lot better than 30% (!) it is certainly higher than we'd like.

Isn't the point here to INCREASE throughput?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Admission Control
Next
From: Takahiro Itagaki
Date:
Subject: Re: patch (for 9.1) string functions