RE: v7.1b4 bad performance

Поиск
Список
Период
Сортировка
От Schmidt, Peter
Тема RE: v7.1b4 bad performance
Дата
Msg-id F1DC8388AD52D411B83B00D0B774D6EB1928E6@winmail.prismedia.com
обсуждение исходный текст
Ответ на v7.1b4 bad performance  ("Schmidt, Peter" <peter.schmidt@prismedia.com>)
Список 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 по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: RE: v7.1b4 bad performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: v7.1b4 bad performance