| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Gerry Reno" <greno(at)verizon(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: join on three tables is slow |
| Date: | 2007-12-11 06:00:12 |
| Message-ID: | 162867790712102200m2144573bw7447e0eff6720d55@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 11/12/2007, Gerry Reno <greno(at)verizon(dot)net> wrote:
> 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?
>
send execution plan and we can see. Maybe you need a cast on every
row, because '1' is varchar. Try e.active = true
Pavel
> Gerry
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerry Reno | 2007-12-11 13:23:54 | Re: join on three tables is slow |
| Previous Message | Richard Broersma Jr | 2007-12-11 04:50:02 | Re: Insert Rule, Multiple Insert, Update Problem |