[postgis-users] Trying to figure out how statistics for the plannerwork

Steve Wormley steve at wormley.com
Fri Mar 10 10:49:15 PST 2006


Thanks for the responses on this issue.

I finally broke down and enabled DEBUG_GEOMETRY_STATS in lwgeom_estimate.c
and realized that the standard deviation computation was optimizing out this
section of data from the created histogram.

Since my data isn't normally distributed enough for USE_STANDARD_DEVIATION
to be useful, I disabled it and ended up with much better estimates for the
areas like this with only a few thousand points.

Thanks,
-Steve Wormley





More information about the postgis-users mailing list