[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Controlling PostGIS memory usage
From:       Sandro Santilli <strk () keybit ! net>
Date:       2014-03-28 14:56:37
Message-ID: 20140328145637.GA9201 () localhost
[Download RAW message or body]

On Thu, Mar 27, 2014 at 11:25:05AM -0500, Dan Gast wrote:

> overcommit = 2 is definitely the best choice in this situation (i.e.
> give the daemon a chance to give up gracefully), but I still don't
> understand why memory balloons in the first place.

ST_Buffer is known to possibly use a lot of memory, especially
with round endpoints. See if/how things change with "endcap=flat".

--strk;
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]