Also if you do have indexes, can you run a "VACUUM ANALYZE", so that the indexes will be used?
Cheers, Rémi-C 2013/11/15 Rémi Cura <[email protected]> > 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
