"Surabhi Ahuja " <[EMAIL PROTECTED]> writes:
> why is it not searching the indexes(index scan)? and how can i make such a
> query much faster?
130 values out of 3,000 is 4.3% of the table. If you have narrow records with,
say, 20 per page that would mean reading most of the pages out of the tabl
try and see, and then tell us
what you saw.
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Surabhi Ahuja
Sent: Tuesday, May 17, 2005 10:13
PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] regarding IN
clause
I have a
table where the primary key "i
Title: regarding IN clause
I have a table where the primary key "id" is a serial key.
now i have a query to this table where in, i have to get information related to a set of ids.
This set contains around 130 ids.
I was thinking that i can form a select statement of the form
select * from
