[postgis-devel] Strange result about spatial indexes?

[Tom Lane]

Paul Ramsey <pramsey at cleverelephant.ca> writes:
> gist_consistent is called a great deal, and for each call it gets
> handed a pointer to a geometry. the consistency check is just whether
> the bounding box of the key overlaps the bounding box of the geometry.
>  rather than detoast the whole geometry we detoast the front slice
> that contains the box, and then run the test.

Oh, wait, I see now: the detoast operation must be happening on the
non-index argument.  This is the same problem we looked at a year or
so ago, and failed to solve at the time.  Somehow or other it'd be good
to do a forcible detoasting of an index scankey argument once before the
index gets probed, instead of repeating that work during each index
comparison.

			regards, tom lane