[postgis-users] Where does Postgres end and PostGIS begin?

forkandwait forkandwait at gmail.com
Mon Jul 25 12:34:43 PDT 2011


Ragi Burhum <rburhum <at> gmail.com> writes:

> Brent and Sean are correct. Nevertheless, it is worth noting that if you are
trying to do k nearest neighbor queries, PostgreSQL 9.1 has  much better (as in
orders of magnitude) indexing support for this particular scenario.
See http://www.depesz.com/index.php/2010/12/11/waiting-for-9-1-knngist/ 

It is worth noting that the "geometry" native to postgres is very useful for
building tricky multidimensional indices and getting distances in a sort of
"state space" analysis. 

For actual mapping of stuff on the ground, Postgis is way more appropriate.






More information about the postgis-users mailing list