Postgres Pro
Downloads
Home   >   mailing lists

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

From Abandoned
Subject Select too many ids..
Date
Msg-id 1191261972.969283.208790@o80g2000hse.googlegroups.com
Whole thread Raw
Responses Re: Select too many ids..  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Select too many ids..  ("Rodrigo De León" <rdeleonp@gmail.com>)
List pgsql-general
Tree view 
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..

pgsql-general by date:

Previous
From: "Jason L. Buberel"
Date:
Subject: Re: Strange discrepancy in query performance...
Next
From: Goboxe
Date:
Subject: Re: Partitioned table limitation