Re: Slow DELETE with IN clausule - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Slow DELETE with IN clausule
Date
Msg-id 200211191436.19287.richardh@archonet.com
Whole thread Raw
In response to Slow DELETE with IN clausule  (Jirka Novak <j.novak@netsystem.cz>)
List pgsql-performance
On Tuesday 19 Nov 2002 2:26 pm, Jirka Novak wrote:
> Hello,
>
>    does have IN operator in WHERE clausule any "undocumented" slowdown?

Yes, but I thought it was documented somewhere. It's certainly been discussed
on the lists. Search the archives for IN/EXISTS. If you can rewrite your
query with an EXISTS clause you should see a big improvement.

http://archives.postgresql.org

--
  Richard Huxton
  Archonet Ltd

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Slow DELETE with IN clausule
Next
From: Nikk Anderson
Date:
Subject: Re: selects from large tables