Re: Select too many ids..

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: Abandoned <besturk(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Select too many ids..
Date: 2007-10-02 16:31:42
Message-ID: a55915760710020931m72f26bc4g14dcedd6976620c6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/1/07, Abandoned <besturk(at)gmail(dot)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...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Charnoky 2007-10-02 16:48:35 Re: more problems with count(*) on large table
Previous Message Scott Marlowe 2007-10-02 16:31:28 Re: Select too many ids..