Re: [HACKERS] intelligence in writing a query ...

2001-05-30 Thread Tom Lane
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

[HACKERS] intelligence in writing a query ...

2001-05-30 Thread The Hermit Hacker
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