[postgis-users] Error: Out of memory DETAIL: Failed on request of size 8
googling1000 at yahoo.com
Tue May 20 03:54:15 PDT 2008
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
ST_Intersection(v.the_geom, m.the_geom) AS intersection_geom,
ST_Area(v.the_geom) AS va_area,
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
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.
More information about the postgis-users