[postgis-users] Where does Postgres end and PostGIS begin?
Paragon Corporation
lr at pcorp.us
Wed Jul 27 10:36:49 PDT 2011
I'm using PostGIS 2.0 with PostgreSQL 9.1 beta 3 (the 2.0), and we had
backported these fixes to 1.5.3 so
Both 1.5.3 and 2.0 should work fine with PostgreSQL 9.1 betas.
Note they won't work for the alpha releases.
Regina
http://www.postgis.us <http://www.postgis.us/>
_____
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Aren
Cambre
Sent: Wednesday, July 27, 2011 11:29 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Where does Postgres end and PostGIS begin?
I looked into this more, and I'm guessing the answer is "yes".
Looks like PostGIS 1.5.3 can be used with Postgres 9.1 beta.
I assume that the index used by Postgres has no bearing on how PostGIS
performs. Is this true? However, it may not be true because Postgres will
need additional support from PostGIS to handle GIST indexes on geometry
objects?
Aren
On Mon, Jul 25, 2011 at 2:39 PM, Aren Cambre <aren at arencambre.com> wrote:
Will PostGIS have a release that supports Postgres 9.1 and the new GIST
index when 9.1 comes out?
Aren
On Mon, Jul 25, 2011 at 2:34 PM, forkandwait <forkandwait at gmail.com> wrote:
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.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110727/4a3e384a/attachment.html>
More information about the postgis-users
mailing list