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.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
