Yes , that was the case indeed. I disabled seq scan and it used the index. And
the cost was higher than seq scan.
Thanks a lot for all your replies.
With warm regards.
Vivek J. Joshi.
[EMAIL PROTECTED]
Trikon Electronics Pvt. Ltd.
All science is either physics or stamp collecting.
On 12/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
The index was created before the table was populated. There are 3 rows in
the table for 3 different users. Now when I do a
postgresql will not use index scan for table with 3 rows in it. it is way
faster to use seq scan on it.
depesz
am Sat, dem 02.12.2006, um 16:35:47 +0530 mailte [EMAIL PROTECTED] folgendes:
>
> The index was created before the table was populated. There are 3 rows
> in the table for 3 different users. Now when I do a
In this case, with only 3 rows, it is much cheaper to do a seq-scan
instead a index-scan
nt: Sat 12/2/2006 3:05 AM
To: pgsql-general@postgresql.org
Cc:
Subject: [GENERAL] select query not using index
Dear Friends,
I have a table as
\d userpref;
Table "public.userpref"
Column| Typ
Dear Friends,
I have a table as
\d userpref;
Table "public.userpref"
Column| Type | Modifiers
-++
username| character varying(101) | n
