On Tuesday 19 Nov 2002 2:26 pm, Jirka Novak wrote:
> 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.
In response to
pgsql-performance by date
|Next:||From: Andrew Sullivan||Date: 2002-11-19 14:39:39|
|Subject: Re: Slow DELETE with IN clausule|
|Previous:||From: Jirka Novak||Date: 2002-11-19 14:26:09|
|Subject: Slow DELETE with IN clausule|