Re: Index usage question

I have experienced the following problem, maybe they are related:

I create a table with
    create table test (id int, name char(10));

then I create an index on it with
    create index test_idx on test (id);

After populating my table, the query
    select id from test where id='1';

uses index scan.

However when I only create the index AFTER inserting rows into the table,
the index is not being used for the evaluation,
even if I run vacuum / vaccum analyze on test;

I would also appreciate some help with this.

Thank you,
Norbert