Bill Moseley <moseley@xxxxxxxx> writes:
> ws2=> select count(*) from person_role;
> count
> -------
> 123
> (1 row)
> ...
> -> Seq Scan on person_role (cost=0.00..2.83 rows=1 width=4) (actual time=0.130..0.165 rows=1 loops=1)
> Filter: ((role = 2) AND (person = 94))
> Why does it say "Seq Scan" on person_role?
Probably because it doesn't consider that table big enough to warrant
using an index.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
