[postgis-devel] Re: [HACKERS] GiST -- making my index faster makes is slower

David Blasby dblasby at refractions.net
Mon Apr 19 13:41:11 PDT 2004

I tracked the problem down to the "penalty" function used to build the 
tree.   Basically, it compares the area of the bounding boxes.

There wasnt enough precision in the area calculations - instead of 
giving 0.0 it would give numbers in the[+-]10^-6 range.  This really 
screwed up how the tree was being built.

I cast the float to doubles when calculating area, and it all works well 


More information about the postgis-devel mailing list