[postgis-users] Over-complicated shapes slowing down my queries?
strk at keybit.net
Wed Mar 21 02:01:29 PDT 2012
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.
| __/ | Delivering high quality PostGIS 2.0 !
| / 2.0 | http://strk.keybit.net - http://vizzuality.com
More information about the postgis-users