Hi, I just installed postgres and postGIS (which is used to work with spatial data). The following script will create a table of spatial data that is an intersection of two tables (bc_voting_areas and bc_municipality).
CREATE TABLE pg_voting_areas AS SELECT ST_Intersection(v.the_geom, m.the_geom) AS intersection_geom, ST_Area(v.the_geom) AS va_area, v.*, m.name FROM bc_voting_areas v, bc_municipality m WHERE ST_Intersects(v.the_geom, m.the_geom) AND m.name = 'PRINCE GEORGE'; I keep getting an error that says: Error: Out of memory DETAIL: Failed on request of size 8 Am I running out of RAM? Help will be highly appreciated. Thanks in advance. PS. I don't know if this is relevant. But, work_mem and some other parameters inside postgresql.conf are not set. Here is a portion of the file: shared_buffers = 32MB #temp_buffers = 8MB #max_prepared_transactions = 5 #work_mem = 1MB #maintenance_work_mem = 16MB #max_stack_depth = 2MB -- View this message in context: http://www.nabble.com/Error%3A-Out-of-memory-DETAIL%3A-Failed-on-request-of-size-8-tp17336283p17336283.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
