St9bad_alloc GEOS throws intersect error!

[marquis103]

I have a huge repository of geospatial data (17M) data objects. I'm attempting to build a view of the data by United States Command area. I have a shapefile built that divides countries up by polygon and command area. I can build all command areas except for northcom (United States, Puerto Rico, Canada, Mexico). The rest of the entire world builds great. I can't attach the geometries because I can't see which ones are causing the errors.

I just always get: NOTICE: St9bad_alloc CONTEXT: SQL statement "CREATE TABLE products_by_location_mv AS SELECT * FROM vw_products_by_location" PL/pgSQL function "create_matview" line 17 at EXECUTE statement ERROR: GEOS intersects() threw an error! CONTEXT: SQL statement "CREATE TABLE products_by_location_mv AS SELECT * FROM vw_products_by_location" PL/pgSQL function "create_matview" line 17 at EXECUTE statement

but no real documentation on an error to see what the case may be. All the polygons return valid. Is there anything I can do to problem get an idea of what geometries are causing the errors?

I'm on Windows 64 bit 2008 32GB Memory Postgres 8.3 Postgis 1.5.2 GEOS 3.2

[strk]

GEOS-3.2.2 was released to fix a memory leak, see if it still happens there. Even better if you try with a development snapshot as of today, to become 3.3.0 soon.

[strk]

Lack of response...