[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