[postgis-devel] Calling Index Genii

Andrea Peri aperi2007 at gmail.com
Thu Dec 30 00:50:31 PST 2010


>On my lap top the loading and index building take about the same
>amount of time, but the query runs in about 1ms for the old index and
>about 5ms for the new one. My assumption (thus unconfirmed) is that
>the problem is not in the consistent checks (doing things like
>reducing the size of the slice detoasted to the minimum necessary for
>2d queries only improved the times by about 10%) but rather in the
>tree itself: that the new index is just building a crappier tree, so
>the query has to traverse more of it to get the same answer.

There even an increase of memory resource needed ?

To test this version there is a new key setting to apply in the .configure,
or need to change manually the definitions ?

-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20101230/98f15e67/attachment.html>


More information about the postgis-devel mailing list