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.
-Steve
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)"
SELECT *
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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
