Re: Strange indexing - Mailing list pgsql-general

From Tom Lane
Subject Re: Strange indexing
Date
Msg-id 29802.1020100333@sss.pgh.pa.us
Whole thread Raw
In response to Strange indexing  (Uros Gruber <uros@sir-mag.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Jenkins
Date:
Subject: Re: What popular, large commercial websites run
Next
From: Joshua Drake
Date:
Subject: Re: What popular, large commercial websites run