Re: Air-traffic benchmark

----- "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