Re: Sync Rep and shutdown Re: Sync Rep v19
От | Yeb Havinga |
---|---|
Тема | Re: Sync Rep and shutdown Re: Sync Rep v19 |
Дата | |
Msg-id | AANLkTinYRqDU=zkJSPAy+f2BiYhNCX_NomtDRTBWNvA4@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Sync Rep and shutdown Re: Sync Rep v19 (Yeb Havinga <yebhavinga@gmail.com>) |
Ответы |
Re: Sync Rep and shutdown Re: Sync Rep v19
|
Список | pgsql-hackers |
<div class="gmail_quote">On Mon, Mar 21, 2011 at 7:51 PM, Yeb Havinga <span dir="ltr"><<a href="mailto:yebhavinga@gmail.com">yebhavinga@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">On 2011-03-2118:04, Robert Haas wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1pxsolid rgb(204, 204, 204); padding-left: 1ex;"> On Mon, Mar 21, 2011 at 12:29 PM, Yeb Havinga<<a href="mailto:yebhavinga@gmail.com"target="_blank">yebhavinga@gmail.com</a>> wrote:<br /><blockquote class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> pgbench-i -s 50 test<br /> Two runs of "pgbench -c 10 -M prepared -T 600 test" with 1 sync standby -<br /> server configsetc were mailed upthread.<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left:1px solid rgb(204, 204, 204); padding-left: 1ex;"> - performance as of commit e148443ddd95cd29edf4cc1de6188eb9cee029c5<br/></blockquote> 1158 and 1306 (avg 1232)<br /><blockquote class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> - performanceas of current git master<br /></blockquote> 1181 and 1280 (avg 1230,5)<br /><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> - performance as of currentgit master with<br /> sync-standbys-defined-rearrangement applied<br /></blockquote> 1152 and 1269 (avg 1210,5)<br/></blockquote></blockquote><br /></div><br /> IMO what these tests have shown is that there is no 20% performancedifference between the different versions. To determine if there are differences, n should be a lot higher, orperhaps a single one with a very large duration.</blockquote><br />pgbench -T 3600:<br /><br />sync-standbys-defined-rearrangement1270 tps<br />current git master 1306 tps<br /><br />-- <br />Yeb Havinga<br /><a href="http://www.mgrid.net/"target="_blank">http://www.mgrid.net/</a><br />Mastering Medical Data<br /><br /></div><br />
В списке pgsql-hackers по дате отправления: