[postgis-users] Why should these boxes intersect?

DrYSG ygutfreund at draper.com
Mon Jul 23 09:59:48 PDT 2012


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.



More information about the postgis-users mailing list