Uros Gruber <uros@sir-mag.com> writes:
> explain select * from test where parent = '1';
> Seq Scan on test (cost=0.00..1.07 rows=1 width=17)
> Why i there no index scan if i create index. I also run
> vacuum on this table.
After the vacuum, the planner knows that your table is too small to
bother with an indexscan. Try putting in a more realistic amount of
data.
regards, tom lane