<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-cite-prefix">El 19/12/13 19:22, Rémi Cura escribió:<br>
</div>
<blockquote
cite="mid:CAJvUf_t7hV4xtpSn_b1DEu3Br9frxEVKT1V3=Tb=7uo1U7=u2Q@mail.gmail.com"
type="cite">
<div dir="ltr">it is a regular sql command :
<div>use pgadmin or psql</div>
<div><br>
</div>
<div>vacuum full analyze;</div>
</div>
</blockquote>
i'll do a full analysis vacuum to my DB ok.
<blockquote
cite="mid:CAJvUf_t7hV4xtpSn_b1DEu3Br9frxEVKT1V3=Tb=7uo1U7=u2Q@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><br>
</div>
<div><br>
</div>
<div>To execute by pieces, there are many possibilities,</div>
<div>one would be to use pgscript.</div>
<div>The idea is to split your big query into smaller queries.</div>
</div>
</blockquote>
and , how can i do it, i mean, how can i split my big query, in the
case of only this
<br>
"CREATE TABLE SPLITED AS<br>
SELECT ST_Split(b.the_geom,z.the_geom) AS the_geom<br>
FROM public.mapa_base_141213 b, public.all_lines_merged z;"<br>
<br>
how can i do it<br>
<blockquote
cite="mid:CAJvUf_t7hV4xtpSn_b1DEu3Br9frxEVKT1V3=Tb=7uo1U7=u2Q@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><br>
</div>
<div>Cheers,</div>
<div>Rémi-C</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/12/19 <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:islanis@infomed.sld.cu" target="_blank">islanis@infomed.sld.cu</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">"Rémi
Cura" <<a moz-do-not-send="true"
href="mailto:remi.cura@gmail.com" target="_blank">remi.cura@gmail.com</a>>
escribió:
<div class="im">
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
most likely you havn't !<br>
I don't know your os so answering is difficult.<br>
</blockquote>
</div>
y have XP sp2, and 1Gb of ram, dual core 1.6ghz
<div class="im"><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
If you have the size of fb free on list,<br>
you can try a<br>
VACUUM FULL ANALYZE<br>
<br>
then try again =)<br>
Other wise, you may have to do you computing piece by
piece.<br>
</blockquote>
</div>
how can i do this
<div class="HOEnZb">
<div class="h5"><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
Cheers,<br>
Rémi-C<br>
<br>
<br>
2013/12/19 <<a moz-do-not-send="true"
href="mailto:islanis@infomed.sld.cu" target="_blank">islanis@infomed.sld.cu</a>><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
ok i execute this:<br>
//------------------------------------<br>
DROP TABLE IF EXISTS SPLITED;<br>
CREATE TABLE SPLITED AS<br>
SELECT ST_Split(b.the_geom,z.the_geom) AS the_geom<br>
FROM public.mapa_base_141213 b,
public.all_lines_merged z;<br>
UPDATE SPLITED SET the_geom =
ST_SetSRID(the_geom,4326);<br>
SELECT Populate_Geometry_Columns('public.SPLITED'::regclass);<br>
ALTER TABLE SPLITED ADD column gid serial;<br>
ALTER TABLE SPLITED ADD COLUMN dato character
varying;<br>
ALTER TABLE SPLITED ADD PRIMARY KEY (gid);<br>
<br>
<br>
DROP TABLE IF EXISTS collectionExtracted;<br>
CREATE TABLE collectionExtracted AS<br>
SELECT ST_CollectionExtract(b.the_geom,3) AS
the_geom<br>
FROM public.SPLITED b;<br>
UPDATE SPLITED SET the_geom =
ST_SetSRID(the_geom,4326);<br>
SELECT Populate_Geometry_Columns('public.collectionExtracted'::regclass);<br>
ALTER TABLE collectionExtracted ADD column gid
serial;<br>
ALTER TABLE collectionExtracted ADD COLUMN dato
character varying;<br>
ALTER TABLE collectionExtracted ADD PRIMARY KEY
(gid);<br>
<br>
<br>
DROP TABLE IF EXISTS dumped;<br>
CREATE TABLE dumped AS<br>
SELECT (ST_Dump(b.the_geom)).geom AS the_geom<br>
FROM public.rad_solar_directa b;<br>
UPDATE dumped SET the_geom =
ST_SetSRID(the_geom,4326);<br>
SELECT Populate_Geometry_Columns('public.dumped'::regclass);<br>
ALTER TABLE dumped ADD column gid serial;<br>
ALTER TABLE dumped ADD COLUMN dato character
varying;<br>
ALTER TABLE dumped ADD PRIMARY KEY (gid);<br>
///-------------------------------------------------------<br>
and i get this error<br>
//---------------------------------<br>
ERROR: no se pudo extender el archivo
«base/604204/609808.5»: No space<br>
left on device<br>
HINT: Verifique el espacio libre en disco.<br>
<br>
********** Error **********<br>
<br>
ERROR: no se pudo extender el archivo
«base/604204/609808.5»: No space<br>
left on device<br>
Estado SQL:53100<br>
Sugerencias:Verifique el espacio libre en disco.<br>
<br>
//--------------------------------------------------------<br>
and i have 11,5Gb of free space what can i do to
solve this problem now.<br>
<br>
<br>
--<br>
<br>
</blockquote>
<br>
</blockquote>
<br>
<br>
<br>
</div>
</div>
<div class="HOEnZb">
<div class="h5">
----------------------------------------------------------------<br>
This message was sent using IMP, the Internet Messaging
Program.<br>
<br>
<br>
<br>
--<br>
<br>
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<br>
<br>
Infomed: <a moz-do-not-send="true"
href="http://www.sld.cu/" target="_blank">http://www.sld.cu/</a><br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>