[postgis-users] PostGIS kills all connections to the PostgreSQLserver

[Michael de Armas (Micotan)]

Thanks for your solution. However, I believe the Buffer algorithm should be 
improved to avoid this work around that only would complicate an automation 
process and is still taking a while.

I don't think there's any quality problem with the shape file, the boundary 
is not simple because is following a river. If there was such a quality 
problem, how would I explain that ArcGIS does the same buffer (on that very 
shape) in 2 seconds maximum, and they are even rendering.

Bruce Rindahl wrote:
> My guess as to why this is happening is the shapefile is really poor 
> quality
> with intersections (interior loops etc.)  Where did you get it?  ESRI maps
> and data CD?
> The fix is to do multiple buffers.  I tested your query and it ran in 234
> seconds (20000 buffer).
> I then ran:
> SELECT area(buffer(buffer(buffer(transform(GeomFromText('POLYGON((....
>   ......................
> ......))', 4267), 32039), 1000), 9000), 10000);
>
> and got the same result in 25 seconds.  I think the first buffer in effect
> cleans out the weird parts of the shape and then the rest are acting on a
> cleaner shape.   A 60,000 buffer was done in 26 seconds.
> Hope an order of magnitude helps!
>
> Bruce Rindahl
>