Postgres Pro
Downloads
Home   >   mailing lists

Re: join on three tables is slow - Mailing list pgsql-sql

From Gerry Reno
Subject Re: join on three tables is slow
Date
Msg-id 475E111B.6060203@verizon.net
Whole thread Raw
In response to Re: join on three tables is slow  (Shane Ambler <pgsql@Sheeky.Biz>)
Responses Re: join on three tables is slow
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Scott
Date:
Subject: Insert Rule, Multiple Insert, Update Problem
Next
From: Richard Broersma Jr
Date:
Subject: Re: Insert Rule, Multiple Insert, Update Problem