Re: [SQL] join on three tables is slow

[Gerry Reno]

Ok, I've been playing around with this SQL some more and I found that if 
I remove this:
e.active = '1'
from the query that the query now completes in 5 seconds.  Nothing else 
has anywhere near the impact of this boolean condition.  So what is it 
about this boolean field that is causing so much delay?

Gerry


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

               http://www.postgresql.org/about/donate