Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group