[postgis-devel] Lacking of exact knn-gist?

maplabs at light42.com maplabs at light42.com
Fri Jun 27 10:48:11 PDT 2014

Alexander -

  there are some images here that might be useful.. 
I dont know exactly what the question is, but, this post is an attempt 
at showing several distance searchs and the results. 


Brian M Hamlin
OSGeo California Chapter

On Fri, 27 Jun 2014 21:29:58 +0400, Alexander Korotkov  wrote:


Turning back to this topic. Could you prepare dump and SQL examples, please? 

With best regards,
Alexander Korotkov. 

On Fri, Jan 17, 2014 at 6:04 PM, Paul Ramsey


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)


You can pull the NYC roads data from the associated data package and 
replicate the results. 
I can prepare something more plug-n-play (dump file and SQL examples) 
when I get back home if needed. 


Paul Ramsey

On January 17, 2014 at 9:01:33 AM, Alexander Korotkov 
(aekorotkov at gmail.com) wrote:

You may take a look at my patch to PostgreSQL enabling exact knn-gist:

Ideally, it could be in 9.4. But I expect serious critics about 
accessing heap from gist is fundamentally bad design. 
Test cases are very welcome. It would be very nice to have them 
before January 19. I know it very soon, but in this case I can 
include them to PGCon proposal. 


postgis-devel mailing list
postgis-devel at lists.osgeo.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140627/598c8bdb/attachment.html>

More information about the postgis-devel mailing list