most likely you havn't ! I don't know your os so answering is difficult. 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. Cheers, Rémi-C 2013/12/19 <[email protected]> > 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. > > > -- >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
