Re: Performance of request of type WHERE ... IN ( ... ) - Mailing list pgsql-sql

Th,

> > I have performance problem of an request of type ... WHERE ... IN (
> ... ).
> > How to improve performance of this type of request when a group of
> id in the
> > 'in' is important.
> 
> Try WHERE ... EXISTS (...).

The explanation of the difference btw. IN and EXISTS is in the
PostgreSQL FAQ on the web site.

-Josh