<div dir="ltr"><div></div><div>Hi all,<br></div><div>I am here to share with you my Week6 report. You can also find it at [1]<br></div><div><br></div><div><h3 id="gmail-CodingWeek719thJuly-25thJuly" style="font-family:Arial,Verdana,"Bitstream Vera Sans",Helvetica,sans-serif;letter-spacing:-0.018em;break-after:avoid;font-size:14px;border-bottom:1px dashed rgb(221,221,221);padding:0.2em 0.3em 0.1em;color:rgb(0,0,0)">Coding Week 7 (19th July - 25th July)<a class="gmail-anchor" href="https://trac.osgeo.org/postgis/wiki/ImplementSortingMethodsBeforeGistIndexBuilding#CodingWeek719thJuly-25thJuly" title="链接到这一节" style="text-decoration-line:none;color:rgb(215,215,215);border:none;font-size:0.8em;vertical-align:text-top"></a></h3><p style="color:rgb(0,0,0);font-family:Verdana,Arial,"Bitstream Vera Sans",Helvetica,sans-serif;font-size:13px"><strong>Coding Phase </strong>:</p><ul style="color:rgb(0,0,0);font-family:Verdana,Arial,"Bitstream Vera Sans",Helvetica,sans-serif;font-size:13px"><li>Check the implementation of <code style="color:rgb(102,0,0);border:1px solid rgb(238,221,204);border-radius:0.25em;padding:0px 0.3em;background:rgb(250,250,250)">GiST</code> in Postgres</li><li>Test the <code style="color:rgb(102,0,0);border:1px solid rgb(238,221,204);border-radius:0.25em;padding:0px 0.3em;background:rgb(250,250,250)">Buffer hit</code> and <code style="color:rgb(102,0,0);border:1px solid rgb(238,221,204);border-radius:0.25em;padding:0px 0.3em;background:rgb(250,250,250)">Execution Time</code> of index query performance with random data</li></ul><p style="color:rgb(0,0,0);font-family:Verdana,Arial,"Bitstream Vera Sans",Helvetica,sans-serif;font-size:13px"><strong>Plans for next week</strong>:</p><ul style="color:rgb(0,0,0);font-family:Verdana,Arial,"Bitstream Vera Sans",Helvetica,sans-serif;font-size:13px"><li>Do more detailed tests to figure out the reason for performance test results</li><li>Modify the hash functions</li></ul></div><div>The test results are shown in the previous mail. You can check the mailing list archive.If you have any questions or suggestions, please let me know! </div><div><br></div><div>[1] <a href="https://trac.osgeo.org/postgis/wiki/ImplementSortingMethodsBeforeGistIndexBuilding" target="_blank">https://trac.osgeo.org/postgis/wiki/ImplementSortingMethodsBeforeGistIndexBuilding</a><br></div><div><br></div><div>Best regards,</div><div>Han</div></div>