----- "Scott Marlowe" <scott.marlowe@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
