From: Pavel Stehule <pavel.stehule@gmail.com>
To: Gerry Reno <greno@verizon.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: join on three tables is slow
Date: Tue, 11 Dec 2007 07:00:12 +0100
Message-ID: <162867790712102200m2144573bw7447e0eff6720d55@mail.gmail.com> (raw)
In-Reply-To: <475E111B.6060203@verizon.net>
References: <475C96EA.6090002@verizon.net>
<475CC478.7010102@Sheeky.Biz>
<475E111B.6060203@verizon.net>
On 11/12/2007, Gerry Reno <greno@verizon.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pavel.stehule@gmail.com, greno@verizon.net
Subject: Re: join on three tables is slow
In-Reply-To: <162867790712102200m2144573bw7447e0eff6720d55@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox