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

Rémi Cura remi.cura at gmail.com
Thu Dec 19 10:22:59 PST 2013


it is a regular sql command :
use pgadmin or psql

vacuum full analyze;


To execute by pieces, there are many possibilities,
one would be to use pgscript.
The idea is to split your big query into smaller queries.

Cheers,
Rémi-C


2013/12/19 <islanis at infomed.sld.cu>

> "Rémi Cura" <remi.cura at gmail.com> escribió:
>
>
>  most likely you havn't !
>> I don't know your os so answering is difficult.
>>
> y have XP sp2, and 1Gb of ram, dual core 1.6ghz
>
>
>> If you have the size of fb free on list,
>> you can try a
>> VACUUM FULL ANALYZE
>>
>> then try again =)
>> Other wise, you may have to do you computing piece by piece.
>>
> how can i do this
>
>
>> Cheers,
>> Rémi-C
>>
>>
>> 2013/12/19 <islanis at infomed.sld.cu>
>>
>>  ok i execute this:
>>> //------------------------------------
>>> DROP TABLE IF EXISTS SPLITED;
>>> 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;
>>> UPDATE SPLITED SET the_geom = ST_SetSRID(the_geom,4326);
>>> SELECT Populate_Geometry_Columns('public.SPLITED'::regclass);
>>> ALTER TABLE SPLITED ADD column gid serial;
>>> ALTER TABLE SPLITED ADD COLUMN dato character varying;
>>> ALTER TABLE SPLITED ADD PRIMARY KEY (gid);
>>>
>>>
>>> DROP TABLE IF EXISTS collectionExtracted;
>>> CREATE TABLE collectionExtracted AS
>>> SELECT ST_CollectionExtract(b.the_geom,3) AS the_geom
>>> FROM public.SPLITED b;
>>> UPDATE SPLITED SET the_geom = ST_SetSRID(the_geom,4326);
>>> SELECT Populate_Geometry_Columns('public.collectionExtracted'::
>>> regclass);
>>> ALTER TABLE collectionExtracted ADD column gid serial;
>>> ALTER TABLE collectionExtracted ADD COLUMN dato character varying;
>>> ALTER TABLE collectionExtracted ADD PRIMARY KEY (gid);
>>>
>>>
>>> DROP TABLE IF EXISTS dumped;
>>> CREATE TABLE dumped AS
>>> SELECT (ST_Dump(b.the_geom)).geom AS the_geom
>>> FROM public.rad_solar_directa b;
>>> UPDATE dumped SET the_geom = ST_SetSRID(the_geom,4326);
>>> SELECT Populate_Geometry_Columns('public.dumped'::regclass);
>>> ALTER TABLE dumped ADD column gid serial;
>>> ALTER TABLE dumped ADD COLUMN dato character varying;
>>> ALTER TABLE dumped ADD PRIMARY KEY (gid);
>>> ///-------------------------------------------------------
>>> and i get this error
>>> //---------------------------------
>>> ERROR:  no se pudo extender el archivo «base/604204/609808.5»: No space
>>> left on device
>>> HINT:  Verifique el espacio libre en disco.
>>>
>>> ********** Error **********
>>>
>>> ERROR: no se pudo extender el archivo «base/604204/609808.5»: No space
>>> left on device
>>> Estado SQL:53100
>>> Sugerencias:Verifique el espacio libre en disco.
>>>
>>> //--------------------------------------------------------
>>> and i have 11,5Gb of free space what can i do to solve this problem now.
>>>
>>>
>>> --
>>>
>>>
>>
>
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>
>
> --
>
> Este mensaje le ha llegado mediante el servicio de correo electronico que
> ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema
> Nacional de Salud. La persona que envia este correo asume el compromiso de
> usar el servicio a tales fines y cumplir con las regulaciones establecidas
>
> Infomed: http://www.sld.cu/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131219/d3c2f6ea/attachment.html>


More information about the postgis-users mailing list