Re: Relation extension scalability
От | Dilip Kumar |
---|---|
Тема | Re: Relation extension scalability |
Дата | |
Msg-id | CAFiTN-vFRHTe_1ayhK01QJTX_oKyuj2xhbw__7NYnnhDT2815Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Relation extension scalability (Amit Kapila <amit.kapila16@gmail.com>) |
Список | pgsql-hackers |
<div dir="ltr"><div class="gmail_extra"><br /><div class="gmail_quote">On Sat, Mar 12, 2016 at 8:37 AM, Amit Kapila <spandir="ltr"><<a href="mailto:amit.kapila16@gmail.com" target="_blank">amit.kapila16@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">Canyou post the numbers for 1, 5, 10, 15, 25 or whatever other multiplier you have tried,so that it is clear that 20 is best?</blockquote></div><br /></div><div class="gmail_extra">I had Tried with 1, 10,20 and 50.<br /><br /></div><div class="gmail_extra">1. With base code it was almost the same as base code.<br /></div><divclass="gmail_extra"><br />2. With 10 thread data it matching with my previous group extend patch data postedupthread<br /><a href="http://www.postgresql.org/message-id/CAFiTN-tyEu+Wf0-jBc3TGfCoHdEAjNTx=WVuxpoA1vDDyST6KQ@mail.gmail.com">http://www.postgresql.org/message-id/CAFiTN-tyEu+Wf0-jBc3TGfCoHdEAjNTx=WVuxpoA1vDDyST6KQ@mail.gmail.com</a><br /><br/></div><div class="gmail_extra">3. Beyond 20 with 50 I did not see any extra benefit in performance number (comparedto 20 when tested 50 with 4 byte COPY I did not tested other data size with 50.).<br /><br />-- <br /><div class="gmail_signature"><divdir="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 по дате отправления: