<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Giuseppe,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If you are willing to do the mentoring I see no issue with it and would be a nice feature to have.<o:p></o:p></p><p class=MsoNormal>We have had a couple of GSOC students in prior years, but none this year to my knowledge. Last one we had implemented the pgAdmin4 geometry viewer plugin, which was a huge benefit to many.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>As far as GSOC for PostGIS goes – we usually do it under the OSGeo umbrella. I can follow-up with OSGeo GSOC community to get PostGIS in the mix, if all are okay with this proposal.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Regina<o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>Giuseppe Broccolo<br><b>Sent:</b> Monday, February 8, 2021 1:58 PM<br><b>To:</b> postgis-devel@lists.osgeo.org<br><b>Subject:</b> [postgis-devel] Google Summer of Code 2021<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Hi,<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Recently <a href="https://commitfest.postgresql.org/29/2276/">this patch</a> which adds more infrastructure to the GiST has been included in PG14. It should speed up the build of a GiST index after some (fast) pre-sorting of the data which needs to be indexed. Some tests for the PG's internal type <span style='font-family:"Courier New"'>point</span> (that uses Zsort as fast pre-sorting of the data) showed that the build is up to 5 times faster. <o:p></o:p></p></div><div><p class=MsoNormal>I'd like to study a possible implementation for PostGIS data types. Basically, it would require to add <a href="https://github.com/glukhovn/postgres/blob/225a49161fae9388651373d4beb8dcba99059339/src/include/access/gist.h#L37">this support function</a> and <a href="https://github.com/glukhovn/postgres/blob/225a49161fae9388651373d4beb8dcba99059339/src/include/access/gist.h#L38">this other one</a> in the operator classes which use the GiST infrastructure (e.g. <a href="https://github.com/postgis/postgis/blob/8b13c3e2f8366d902dbf516ec17de09ae84361f4/postgis/postgis.sql.in#L781">this one</a>).<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I was wondering if we could take the opportunity to have some support even by the students of the Google Summer of Code of this year. I'd be happy to do some mentorship in order to get this done in the 180 hours required by the committee.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>First of all I'd like to ask your opinion: do you think it would be a good idea to involve a student? Is there any other application for PostGIS project at the GSOC?<o:p></o:p></p></div><div><p class=MsoNormal>Link to the <a href="https://opensource.googleblog.com/2020/10/google-summer-of-code-2021-is-bringing.html">GSOC</a> (info about the timeline <a href="https://developers.google.com/open-source/gsoc/timeline">here</a>).<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks,<o:p></o:p></p></div><div><p class=MsoNormal>Giuseppe.<o:p></o:p></p></div></div></div></div></body></html>