Re: correlated delete with "in" and "left outer join"

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: <mike(at)linkify(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: correlated delete with "in" and "left outer join"
Date: 2004-02-27 02:41:36
Message-ID: 76489D66-68CE-11D8-ACF5-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 27, 2004, at 11:26 AM, <mike(at)linkify(dot)com> wrote:

> I'm using postgresl 7.3.2 and have a query that executes very slowly.

<snip />

> I understand that using "in" is not very efficient.
>
> Is there some other way to write this query without the "in"?

NOT EXISTS ( ) is sometimes more efficient. If at all possible, upgrade
to 7.4.1. One of the many things that have improved since 7.3.2 is the
efficiency of queries using IN.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Cohen 2004-02-27 03:08:45 change db encoding
Previous Message mike 2004-02-27 02:26:19 correlated delete with "in" and "left outer join"