You need a way to partition your query into logical pieces . In your case I guess you could compute only some part of "public.mapa_base_141213 b" at a time.
For instance : CREATE TABLE SPLITED AS SELECT ST_Split(b.the_geom,z.the_ geom) AS the_geom FROM public.mapa_base_141213 b, public.all_lines_merged z WHERE b.unique_id > M and b.unique_id < N M and N would be for example : 1 and 100 101 and 200 ... You could dynamically replace the N and M using pgscript ( http://www.pgadmin.org/docs/dev/pgscript.html), with a simple loop. This way you could print what you are doing, and do it in separate transactions. The number would depend on how much time you would like to have for one transaction Cheers, Rémi-C
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
