Re: Move PinBuffer and UnpinBuffer to atomics
От | Dilip Kumar |
---|---|
Тема | Re: Move PinBuffer and UnpinBuffer to atomics |
Дата | |
Msg-id | CAFiTN-teXU+OVke7gtZy7vOq5bA+Ei57Ze-F3QzJ-eV6bdkO=A@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Move PinBuffer and UnpinBuffer to atomics (Dilip Kumar <dilipbalaut@gmail.com>) |
Ответы |
Re: Move PinBuffer and UnpinBuffer to atomics
|
Список | pgsql-hackers |
<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>
В списке pgsql-hackers по дате отправления: