Re: Sync Rep v19
От | Simon Riggs |
---|---|
Тема | Re: Sync Rep v19 |
Дата | |
Msg-id | 1299504818.1696.8783.camel@ebony обсуждение исходный текст |
Ответ на | Re: Sync Rep v19 (Yeb Havinga <yebhavinga@gmail.com>) |
Список | pgsql-hackers |
On Mon, 2011-03-07 at 14:20 +0100, Yeb Havinga wrote: > 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! :-) That looks like good news, thanks. It shows that sync rep is "fairly fast", but it also shows clearly why you'd want to mix sync and async replication within an application. -- Simon Riggs http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services
В списке pgsql-hackers по дате отправления: