index your data if you havent.. 2010/4/1 iKey <[email protected]>
> > Hey, > I've set up a Postgres database with Postgis support. > Now I try to excecute the following query: > > SELECT DISTINCT p.* > FROM punkte p, lines l > WHERE l.tags LIKE '%"highway"="footway"%' > AND CONTAINS(BUFFER(l.the_geom, 500), p.the_geom) > > You can download the SQL's to create the tables from my server: > http://thisisliving.info/sql.zip > > It should return all datasets from the table punkte that are within a > buffer > of 500m around the datasets of the lines table. > Anyway the query works fine, but it's veeeeery slow. It takes about 10 > minutes to get the results (1969). > Now my question is if there is a way to speed up the query a bit. > All help is appreciated. > Thank you > Eike Lüders > > -- > View this message in context: > http://old.nabble.com/Postgres-Postgis-query-very-slow-tp28106198p28106198.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
