RE: v7.1b4 bad performance - Mailing list pgsql-admin

From Schmidt, Peter
Subject RE: v7.1b4 bad performance
Date
Msg-id F1DC8388AD52D411B83B00D0B774D6EB1928E6@winmail.prismedia.com
Whole thread Raw
In response to v7.1b4 bad performance  ("Schmidt, Peter" <peter.schmidt@prismedia.com>)
List pgsql-admin


> -----Original Message-----
> From: The Hermit Hacker [mailto:scrappy@hub.org]

> Okay, am going to guess that all four of these results are with
> CommitDelay=0,

You guessed right. Here are results for ComitDelay=5.

Peter

number of clients: 100
number of transactions per client: 10
number of transactions actually processed: 1000/1000
tps = 24.302740(including connections establishing)
tps = 24.972620(excluding connections establishing)

number of clients: 50
number of transactions per client: 20
number of transactions actually processed: 1000/1000
tps = 29.500925(including connections establishing)
tps = 30.002143(excluding connections establishing)

number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 36.948563(including connections establishing)
tps = 37.118906(excluding connections establishing)

number of clients: 1
number of transactions per client: 1000
number of transactions actually processed: 1000/1000
tps = 46.671071(including connections establishing)
tps = 46.713340(excluding connections establishing)

pgsql-admin by date:

Previous
From: The Hermit Hacker
Date:
Subject: RE: v7.1b4 bad performance
Next
From: Tom Lane
Date:
Subject: Re: v7.1b4 bad performance