[postgis-users] Error: Out of memory DETAIL: Failed on request of size 8

[googling1000]

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.