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

[Mark Cave-Ayland]

Obe, Regina wrote:

> Yap that looks like a typo
>
> Mark did you mean -
>
> explain analyze select count(*) from geography a join
> 	geography b on (b.the_geom && a.centroid) where a.id = 69495;
>
> Hope that helps,
> Regina

Thanks guys.

Yeah, it was just me experimenting with trying to simplify the query down
even further in both forms. So it is likely that the results of this
particular query are just meaningless ;)


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063