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

Re: Slow DELETE with IN clausule

From: Richard Huxton <richardh(at)archonet(dot)com>
To: Jirka Novak <j(dot)novak(at)netsystem(dot)cz>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow DELETE with IN clausule
Date: 2002-11-19 14:36:19
Message-ID: 200211191436.19287.richardh@archonet.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Andrew SullivanDate: 2002-11-19 14:39:39
Subject: Re: Slow DELETE with IN clausule
Previous:From: Jirka NovakDate: 2002-11-19 14:26:09
Subject: Slow DELETE with IN clausule

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