[postgis-users] GEOS union() error

[Kevin Neufeld]

On a linux system you would need to adjust your SHMMAX and SHMMIN settings.
http://www.postgresql.org/docs/8.2/static/kernel-resources.html#SYSVIPC

I'm not sure on a Windows box...

-- Kevin

Lee Keel wrote:
> Sorry to keep on with this, but I have a couple more questions.
>
> I have posted my current postgresql.conf settings below.  I am running PG
> 8.2.3\postgis 1.2.1 on a Vista 64bit dual quad with 8GB Ram.
>
>
> shared_buffers = 1200MB			# min 128kB or max_connections*16kB
> #temp_buffers = 16MB			# min 800kB
> work_mem = 150MB				# min 64kB
>
>
> 1) Why can't I increase any of these settings?  If I increment any one of
> these settings or enable temp_buffers the service will not start.  In fact,
> the service won't even start if I just set shared_buffers = 1200000.  What
> have I got wrong?
>
> 2) I have also tried to do 'set work_mem to 1200000;' as I am executing my
> query and I still get 'Out of memory' errors.  Shouldn't some postgres.exe
> be ramping up in memory before I get that error?  I have added some
> simplifies into my query to try to decrease the size of shapes being brought
> into the buffer and the collection.  This has worked to some degree, but I
> am back to the problem of memory now.  My latest query is doing
> simplify(buffer(simplify(the_geom, 5), 400), 150) and dumping the results to
> a table.  In which I get a bunch of polygons as expected.  But I can't do a
> collect (nor geomunion) on this secondary table without getting 'out of
> memory' error.  I have even tried adding limits as low as 2 and it still
> throws a memory error.  Is this a windows config problem?  Do I need to try
> and upgrade the postgis version to 1.3.1?
>
> Thanks again for all the help.
> Lee
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>