Maybe you can check that you have indexes on both geom column. Cheers,
Rémi-C 2013/12/2 laurent <[email protected]> > Hello, > > Ok sorry for the mistake. So please read the correction : > > ----------------------- > CREATE TABLE example_intersections_a AS (SELECT ST_Intersection > (part_1.geom, part_2.geom)FROM fra_adm0 AS part_1,france_merge_pts1 AS > part_2 WHERE ST_Intersects(part_1.geom, part_2.geom)); > ALTER TABLE example_intersections_a ADD COLUMN id SERIAL; > ALTER TABLE example_intersections_a ADD PRIMARY KEY (id); > ---------------------- > > > My goal is to populate into a new table the points from my raw points > layer > (france_merge_pts1) which contain or touch the surface of my raw surface > polygon (fra_adm0). According to you, my query is good? My point layer is > huge. I launched the query. It is still ongoing. Maybe is there a way to > speed up the process? > > In advance, thank you. > > > > > > -- > View this message in context: > http://postgis.17.x6.nabble.com/ST-intersects-error-message-tp5005029p5005031.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
