[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Why should these boxes intersect?
From:       DrYSG <ygutfreund () draper ! com>
Date:       2012-07-23 16:59:48
Message-ID: 1343062788240-4999088.post () n6 ! nabble ! com
[Download RAW message or body]

It took me 72 hours to add a GIST indexed geography column, but now I can
report the results:

I don't see any noticable performance hit in going from goem x geom
intersection to geog x geog intersection (where the geog column in the table
is 20M in size).

I think this is due to the fact that the search is disk speed limited.




--
View this message in context: \
http://postgis.17.n6.nabble.com/Why-should-these-boxes-intersect-tp4998895p4999088.html
 Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]