[postgis-users] help with the Union of 2 shp

[Rémi Cura]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131227/65a21a2a/attachment.html>