Re: Strange issue with GiST index scan taking far too long - Mailing list pgsql-hackers

On Mon, 2008-06-09 at 14:18 +0100, Mark Cave-Ayland wrote:
> Unfortunately I can't seem to work out why the extra time is 
> disappearing into the index scan when my extra mcatest() function is
> not present,

Hmmm, perhaps implicit casting?

Try this to see if it works better also

select count(*) from geography where centroid 
&& (select the_geom::geometry from geography where id=69495);

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support