Select too many ids..

From: Abandoned <besturk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Select too many ids..
Date: 2007-10-01 18:06:12
Message-ID: 1191261972.969283.208790@o80g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-10-01 18:13:23 Re: usage of indexes for inner joins
Previous Message MrKrinkle 2007-10-01 17:52:45 Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username