It should be finished by now, can you check you have geom indexes on : "ukmajrdbuffer.geom" and "all_lines.the_geom"
How many geoms do you have in "ukmajrdbuffer"? Cheers, Rémi-C 2013/11/15 Rémi Cura <[email protected]> > Hey Sandro, > > Thanks for this, it is at least twice faster =) > > Cheers, > Rémi-C > > > > > 2013/11/15 James David Smith <[email protected]> > >> Thanks both. Geometries now fixed. >> >> The query 'CREATE TABLE lines_for_each_road....' has now been set >> running. Will report back when it's done. I suspect it may take a >> while! >> >> James >> >> On 15 November 2013 11:03, Sandro Santilli <[email protected]> wrote: >> > On Fri, Nov 15, 2013 at 11:50:42AM +0100, Rémi Cura wrote: >> >> Yep, maybe something like >> >> >> >> UPDATE ukmajrdbuffer SET the_geom = ST_MakeValid(the_geom) >> >> WHERE ST_IsValid(the_geom) = FALSE >> > >> > ST_MakeValid internally checks for ST_IsValid, so no need >> > to add the condition (which would run the test twice). >> > >> > --strk; >> > _______________________________________________ >> > 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 >> > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
