[postgis-devel] Re: [postgis-users] GIST index speed

[Paul Ramsey]

On Mon, Jun 16, 2008 at 12:59 PM, Mark Cave-Ayland
<mark.cave-ayland at siriusit.co.uk> wrote:

> So the good news is that the patch has shaved nearly 50% off the overall
> query time. But in comparison to my simple wrapper function that de-TOASTs
> the geometry, it is still 6 times slower for an identical query plan even
> with your patch included.

Coincidentally (?) 50% is the same speed-up I got my removing RECHECK
from the index for this test case.