[postgis-users] ST_Overlaps and performance
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
>> SELECT *
>> FROM portal.catalog as cat
>> WHERE ST_Contains(cat.location,'SRID=4326;POINT(70.9433962
>> 41.5384615)'::geometry) OR
>> 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
More information about the postgis-users