Re: Select in subselect vs select = any array

> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-
> owner@postgresql.org] On Behalf Of Adam Tistler
> Sent: Monday, March 21, 2011 12:17 AM
> To: Pavel Stehule
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Select in subselect vs select = any array
>
> Pavel, thanks for the help.
>
> I increased work_mem from 16MB to 64MB, no difference.  The queries are
> really just a test case.  My actual queries are actual just large
> number of primary keys that I am selecting from the db:
>
> For example:
>    select * from nodes where node_id in ( 1, 2, 3 ..... )
>

What does "large" number of primary keys mean ?

I have seen some "odd" things happen when I passed, carelessly, tens of
thousands of items to an in list for a generated query, but I don't get the
feeling that isn't the case here.




..: Mark