Postgres Pro
Downloads
Home   >   mailing lists

Re: Select too many ids.. - Mailing list pgsql-general

From Rodrigo De León
Subject Re: Select too many ids..
Date
Msg-id a55915760710020931m72f26bc4g14dcedd6976620c6@mail.gmail.com
Whole thread Raw
In response to Select too many ids..  (Abandoned <besturk@gmail.com>)
Responses Re: Select too many ids..
List pgsql-general
Tree view 
On 10/1/07, Abandoned <besturk@gmail.com> wrote:
> Hi..
> I have a id list and id list have 2 million dinamic elements..
> I want to select what id have point..
> I try:
>
> SELECT id, point FROM table WHERE id in (IDLIST)
>
> This is working but too slowly and i need to performance..
>
> I'm sorry my bad english.
> King regards..

DDL please...

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Select too many ids..
Next
From: Mike Charnoky
Date:
Subject: Re: more problems with count(*) on large table