Re: join on three tables is slow

From: Gerry Reno <greno(at)verizon(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: join on three tables is slow
Date: 2007-12-11 04:24:59
Message-ID: 475E111B.6060203@verizon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2007-12-11 04:50:02 Re: Insert Rule, Multiple Insert, Update Problem
Previous Message Scott 2007-12-11 04:23:52 Insert Rule, Multiple Insert, Update Problem