----- "Scott Marlowe" <scott.marlowe@gmail.com> escreveu:
> You do know that indexes in postgresql are not "covering" right?
> I.e.
> after hitting the index, the db then has to hit the table to see if
> those rows are in fact visible. So there's no such thing in pgsql,
> at
> the moment, as an index only scan.
That was just an estimation of effort to reach a tuple through seqscan X indexscan. In both cases the tuple have to be
checked,sure.
Flavio Henrique A. Gurgel
tel. 55-11-2125.4786
cel. 55-11-8389.7635
www.4linux.com.br
FREE SOFTWARE SOLUTIONS