The Hermit Hacker <[EMAIL PROTECTED]> writes:
> 2EXPLAIN SELECT distinct s.gid, s.created, count(i.title) AS images
> FROM status s LEFT JOIN images i ON (s.gid = i.gid AND i.active),
>relationship_wanted rw
> WHERE s.active AND s.status != 0
>AND EXISTS
Tom, with all the work you've been doing inside planner and optimizer, has
there been anything done for 7.1.2 to make how a query is written cause
the backend to be more intelligent?
I'm playing with a query that I just don't like, since its taking ~3min to
run ...
It started as:
EXPLAIN SELEC