[postgis-users] Over-complicated shapes slowing down my queries?

[Sandro Santilli]

On Tue, Mar 20, 2012 at 10:11:15PM -0400, Dan Bernier wrote:

> > Perhaps looks at
> > ST_SimplifyPreserveTopology()
> > with very small tolerances first.
> 
> Thanks for the suggestion, I'll check it out. I'm not familiar enough
> with the terms to understand how it's different from ST_Simplify, but

ST_SimplifyPreserveTopology makes sure not to produce invalid output
and avoid collapses. ST_Simplify doesn't care. 

ST_SimplifyPreserveTopology may take more then twice the time of ST_Simplify.

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'