<div dir="ltr"><div class="gmail_extra">Hi!</div><div class="gmail_extra"><br></div><div class="gmail_extra">Turning back to this topic. Could you prepare dump and SQL examples, please? </div><div class="gmail_extra"><br clear="all">

<div><span style="font-family:arial,sans-serif;font-size:13px">------</span><br style="font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial,sans-serif;font-size:13px">With best regards,</span><br style="font-family:arial,sans-serif;font-size:13px">

<span style="font-family:arial,sans-serif;font-size:13px">Alexander Korotkov.</span><br></div><br><div class="gmail_quote">On Fri, Jan 17, 2014 at 6:04 PM, Paul Ramsey <span dir="ltr"><<a href="mailto:pramsey@cleverelephant.ca" target="_blank">pramsey@cleverelephant.ca</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">

Alex,</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">This piece of the workshop gives some visuals about how unpleasant reasoning abound nearest neighbour using boxes is. (It’s almost embarrassing trying to explain it to people)</div>

<div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><a href="http://workshops.boundlessgeo.com/postgis-intro/knn.html" target="_blank">http://workshops.boundlessgeo.com/postgis-intro/knn.html</a></div>

<div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">You can pull the NYC roads data from the associated data package and replicate the results. </div>

<div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">I can prepare something more plug-n-play (dump file and SQL examples) when I get back home if needed.</div><div class=""><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">

<br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgb(0,0,0);margin:0px">P.</div> <div><div><br></div><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br>Paul Ramsey<br><a href="http://cleverelephant.ca" target="_blank">http://cleverelephant.ca</a><div>

<a href="http://postgis.net" target="_blank">http://postgis.net</a></div></div> <br></div><div class=""><p style="color:rgb(160,160,168)">On January 17, 2014 at 9:01:33 AM, Alexander Korotkov (<a href="mailto://aekorotkov@gmail.com" target="_blank">aekorotkov@gmail.com</a>) wrote:</p>

 <blockquote type="cite"><span><div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">

<br>You may take a look at my patch to PostgreSQL enabling exact knn-gist:</div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">

<a href="http://www.postgresql.org/message-id/CAPpHfdu_qBLNRnv-r=_tofZYYa6-r=Z5_MGF4_phAOkWcYxfRg@mail.gmail.com" target="_blank">http://www.postgresql.org/message-id/CAPpHfdu_qBLNRnv-r=_tofZYYa6-r=Z5_MGF4_phAOkWcYxfRg@mail.gmail.com</a><br>

</div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">

Ideally, it could be in 9.4. But I expect serious critics about accessing heap from gist is fundamentally bad design.</div><div class="gmail_extra" style="color:rgb(0,0,0);font-family:helvetica;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">

Test cases are very welcome. It would be very nice to have them before<span> </span><a href="http://airmail.calendar/2014-01-19%2012:00:00%20EST" target="_blank">January 19.</a><span> </span>I know it very soon, but in this case I can include them to PGCon proposal.</div>

<br></div></span></blockquote></div></div></blockquote></div><br></div></div>