[postgis-users] Memory Bug in PostGIS Query

maplabs at light42.com maplabs at light42.com
Sun Oct 23 12:35:04 PDT 2011

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


Brian Hamlin
OSGeo California Chapter
415-717-4462 cell

More information about the postgis-users mailing list