<div dir="ltr"><div class="gmail_extra"><br /><div class="gmail_quote">On Sun, Jan 31, 2016 at 11:44 AM, Dilip Kumar
<spandir="ltr"><<a href="mailto:dilipbalaut@gmail.com" target="_blank">dilipbalaut@gmail.com</a>></span>
wrote:<br/><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex"><divclass="gmail_extra">By looking at the results with scale factor 1000 and 100 i
don'tsee any reason why it will regress with scale factor 300.<br /><br /></div><div class="gmail_extra">So I will run
thetest again with scale factor 300 and this time i am planning to run 2 cases. <br />1. when data fits in shared
buffer<br/>2. when data doesn't fit in shared buffer.</div></blockquote></div><br /></div><div class="gmail_extra">I
haverun the test again with 300 S.F and found no regression, in fact there is improvement with the patch like we saw
with1000 scale factor.<br /><br />Shared Buffer= 8GB <br />max_connections=150 <br />Scale Factor=300
<br /> <br />./pgbench -j$ -c$ -T300 -M prepared -S postgres <br /> <br />Client
Base Patch<br />1 19744 19382<br />8 125923 126395<br />32 313931 333351<br />64 387339
496830<br/>128 306412 350610<br /> <br />Shared Buffer= 512MB <br />max_connections=150 <br
/>ScaleFactor=300 <br /> <br />./pgbench -j$ -c$ -T300 -M prepared -S postgres <br /> <br
/>Client Base Patch<br />1 17169 16454<br />8 108547 105559<br />32 241619 262818<br />64
206868 233606<br />128 137084 217013 <br /></div><div class="gmail_extra"><br clear="all" /><br />-- <br
/><divclass="gmail_signature"><div dir="ltr"><span style="color:rgb(80,0,80);font-size:12.8px">Regards,</span><br
style="color:rgb(80,0,80);font-size:12.8px"/><span style="color:rgb(80,0,80);font-size:12.8px">Dilip Kumar</span><br
style="color:rgb(80,0,80);font-size:12.8px"/><span style="color:rgb(80,0,80);font-size:12.8px">EnterpriseDB: </span><a
href="http://www.enterprisedb.com/"style="color:rgb(17,85,204);font-size:12.8px"
target="_blank">http://www.enterprisedb.com</a><br/></div></div></div></div>