[postgis-users] No index usage on geography query plan?

Paul Ramsey pramsey at opengeo.org
Tue Jun 1 09:36:47 PDT 2010


It's mostly a matter of being globally careful about not reading
things into memory that you don't need. For 2.0 we're just going to
use the new index structure, so the 2D index will use the same
machinery as the geography index.

P.

On Tue, Jun 1, 2010 at 12:03 PM, Martin Davis <mbdavis at refractions.net> wrote:
>
>
> Paul Ramsey wrote:
>>
>> FYI, it is not the index that is slower, it is the op. The index is
>> actually (surprisingly) faster.
>>
> Wow, that's unexpected.  Do you know why this is?  Is there a message there
> for the current 2D GIST index?
>
> --
> Martin Davis
> Senior Technical Architect
> Refractions Research, Inc.
> (250) 383-3022
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list