Re: Sync Rep v19

Поиск
Список
Период
Сортировка
От Yeb Havinga
Тема Re: Sync Rep v19
Дата
Msg-id 4D74DB88.9040101@gmail.com
обсуждение исходный текст
Ответ на Re: Sync Rep v19  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Sync Rep v19  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 2011-03-07 01:37, Simon Riggs wrote:
> On Sat, 2011-03-05 at 21:11 +0100, Yeb Havinga wrote:
>
>> I also got a first first>  1000 tps score
> The committed version should be even faster. Would appreciate a retest.
>
pgbench 5 minute test pgbench -c 10 -M prepared -T 300 test
dbsize was -s 50, 1Gbit Ethernet

1 async standby
tps = 2475.285931 (excluding connections establishing)

2 async standbys
tps = 2333.670561 (excluding connections establishing)

1 sync standby
tps = 1277.082753 (excluding connections establishing)

1 sync, 1 async standby
tps = 1273.317386 (excluding connections establishing)

Hard for me to not revert to superlatives right now! :-)

regards,
Yeb Havinga



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jan Urbański
Дата:
Сообщение: Re: pl/python tracebacks
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.