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