| From: | "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com> |
|---|---|
| To: | "'The Hermit Hacker'" <scrappy(at)hub(dot)org>, "Schmidt, Peter" <peter(dot)schmidt(at)prismedia(dot)com> |
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'Michael Ansley'" <Michael(dot)Ansley(at)intec-telecom-systems(dot)com>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | RE: v7.1b4 bad performance |
| Date: | 2001-02-17 05:28:35 |
| Message-ID: | F1DC8388AD52D411B83B00D0B774D6EB1928E6@winmail.prismedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> -----Original Message-----
> From: The Hermit Hacker [mailto:scrappy(at)hub(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-17 06:10:38 | Re: v7.1b4 bad performance |
| Previous Message | The Hermit Hacker | 2001-02-17 05:04:02 | RE: v7.1b4 bad performance |