Re: Sync Rep and shutdown Re: Sync Rep v19 - Mailing list pgsql-hackers

From Yeb Havinga
Subject Re: Sync Rep and shutdown Re: Sync Rep v19
Date
Msg-id AANLkTinYRqDU=zkJSPAy+f2BiYhNCX_NomtDRTBWNvA4@mail.gmail.com
Whole thread Raw
In response to Re: Sync Rep and shutdown Re: Sync Rep v19  (Yeb Havinga <yebhavinga@gmail.com>)
Responses Re: Sync Rep and shutdown Re: Sync Rep v19
List 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 by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: 2nd Level Buffer Cache
Next
From: Tom Lane
Date:
Subject: Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL