From: Gerry Reno <greno@verizon.net>
To: pgsql-sql@postgresql.org
Subject: Re: join on three tables is slow
Date: Mon, 10 Dec 2007 23:24:59 -0500
Message-ID: <475E111B.6060203@verizon.net> (raw)
In-Reply-To: <475CC478.7010102@Sheeky.Biz>
References: <475C96EA.6090002@verizon.net>
<475CC478.7010102@Sheeky.Biz>
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
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: greno@verizon.net
Subject: Re: join on three tables is slow
In-Reply-To: <475E111B.6060203@verizon.net>
* 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