[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