[postgis-users] Spatial Join Performance

[Paul Ramsey]

Eric,

You could replace your Contains(A,B) with
Distance(A,B) < 0.001, which will run a shorter calculation faster 
(until we add a short-circuit to Contains()).

Otherwise your query looks pretty good. If your tables are relatively 
constant, clustering them will speed things up marginally, and make sure 
you've increased your PgSQL settings above the (tiny tiny) defaults.

http://www.varlena.com/GeneralBits/Tidbits/perf.html

Eric Shuman wrote:
> Paul,
> 
> Your analysis of my scenario is correct. Most tax lot polygons are small and
> relatively simple compared to the zone polygons.  Though in some cases the
> lots can be big and cover more than one zone.
> 
> So is the query I am using correct or is there something I can add to work
> around this issue?
> 
> 
> Thanks for the help!
> 
> ---------------
> Eric Shuman
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users