RE: v7.1b4 bad performance
От | Schmidt, Peter |
---|---|
Тема | RE: v7.1b4 bad performance |
Дата | |
Msg-id | F1DC8388AD52D411B83B00D0B774D6EB1928E5@winmail.prismedia.com обсуждение исходный текст |
Ответ на | v7.1b4 bad performance ("Schmidt, Peter" <peter.schmidt@prismedia.com>) |
Ответы |
RE: v7.1b4 bad performance
|
Список | pgsql-admin |
> BTW, have you tried pgbench with multiple clients (-c) rather
> than just
> one?
>
> regards, tom lane
I was wrong about multiple clients...
I've seen as many as 230 tps with CommitDelay=0.
Peter
number of clients: 100
number of transactions per client: 10
number of transactions actually processed: 1000/1000
tps = 47.763389(including connections establishing)
tps = 50.660709(excluding connections establishing)
number of clients: 50
number of transactions per client: 20
number of transactions actually processed: 1000/1000
tps = 76.521240(including connections establishing)
tps = 79.924979(excluding connections establishing)
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 103.444345(including connections establishing)
tps = 104.723556(excluding connections establishing)
number of clients: 1
number of transactions per client: 1000
number of transactions actually processed: 1000/1000
tps = 172.223961(including connections establishing)
tps = 172.774743(excluding connections establishing)
В списке pgsql-admin по дате отправления: