[postgis-users] ST_Overlaps and performance

Stephen Woodbridge woodbri at swoodbridge.com
Wed Mar 7 10:53:13 PST 2012

Explain looks good.

Have you done anything to tune postgresql to use more memory or are you 
using the default parameters that came with the install. postgresql by 
default is configured to use minimal memory. If its the default, then I 
would google for "tuning postgresql" and look at shared_buffers 
specifically, there are probably others that can be opened up also but 
it really depends on the amount of memory you have, the OS, what other 
applications are running and using memory concurrently, etc.


On 3/7/2012 1:50 PM, DrYSG wrote:
> The explain query for your query is:
> "Index Scan using loc_idx on metadata cat  (cost=0.00..1050.88 rows=253
> width=845)"
>> FROM portal.catalog as cat
>> WHERE ST_Contains(cat.location,'SRID=4326;POINT(70.9433962
>> 41.5384615)'::geometry) OR
>>         ST_Contains(cat.location,'SRID=4326;POINT(71.9433962
>> 40.5384615)'::geometry)  ;
> --
> View this message in context: http://postgis.17.n6.nabble.com/ST-Overlaps-and-performance-tp4555465p4555707.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list