[postgis-users] Memory Bug in PostGIS Query

[maplabs at light42.com]

Hi -

  a couple of things.. it is the library GEOS that is crashing, ( part of PostGIS )

Is your geometry clean?  consistant ?  what is the assurance level on that?

--

 Next is that you have a huge, powerful computer but you are using only a fraction of the RAM
Try reducing the Max Connections (if you are the primary user) to 60 from 100
then this (for example)

# - Memory -
shared_buffers = 2000MB                 # min 128kB
                                        # (change requires restart)
temp_buffers = 64MB                     # min 800kB

work_mem = 256MB                                # min 64kB
maintenance_work_mem = 256MB            # min 1MB
--

  Next, upgrade your PostGIS and GEOS !!
PostGIS 1.5.x  and GEOS 3.3 I believe are current

  hth
    -Brian

==
Brian Hamlin
GeoCal
OSGeo California Chapter
415-717-4462 cell