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 <[email protected]> > "Rémi Cura" <[email protected]> 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 <[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. >>> >>> >>> -- >>> >>> >> > > > ---------------------------------------------------------------- > 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/ > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
