Thread: Performance of request of type WHERE ... IN ( ... )

Hello,

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.
Thanks for your answers.
Templth





_________________________________________________________________
MSN 8: advanced junk mail protection and 2 months FREE*.
http://join.msn.com/?page=features/junkmail

This is not a jdbc question.  You should ask this on either the
pgsql-sql, pgsql-general or pgsql-performance mail lists.  This has been
discussed many times in the past, so it also might be a good idea to
check the mail archives of those lists.

--Barry

Th Templ wrote:
> Hello,
>
> 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.
> Thanks for your answers.
> Templth
>
>
>
>
>
> _________________________________________________________________
> MSN 8: advanced junk mail protection and 2 months FREE*.
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>