From: mark <dvlhntr@gmail.com>
To: 'Adam Tistler' <atistler@gmail.com>
To: 'Pavel Stehule' <pavel.stehule@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Select in subselect vs select = any array
Date: Mon, 21 Mar 2011 20:55:11 -0600
Message-ID: <01fa01cbe83c$90b146d0$b213d470$@com> (raw)
In-Reply-To: <035B29F0-1441-4FC7-8B24-FAC8DB745C89@gmail.com>
References: <75F42287-42D3-4FD5-AFFA-64B1CE3C0195@gmail.com>
<AANLkTikDbBT69mmGW=2uq9Jzbbeki44ZsXPnsMXqXApt@mail.gmail.com>
<D7BE02F0-7D03-400B-800F-43778243941B@gmail.com>
<AANLkTimTp__+9prmEuFh9q9rfT=La2Vhf172_bz=hEa5@mail.gmail.com>
<035B29F0-1441-4FC7-8B24-FAC8DB745C89@gmail.com>
> -----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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dvlhntr@gmail.com, atistler@gmail.com, pavel.stehule@gmail.com
Subject: Re: Select in subselect vs select = any array
In-Reply-To: <01fa01cbe83c$90b146d0$b213d470$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox