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

[Obe, Regina]

Mark Cave-Ayland <mark.cave-ayland at siriusit.co.uk> writes:
>> postgis=# explain analyze select count(*) from geography a join 
>> geography b on (b.the_geom &&
>> b.centroid) where a.id = 69495;

>Is that query really meaningful?  You seem to be forming the
>cartesian product of a subset of a with an unrelated subset of b.

>			regards, tom lane

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
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.