| From: | "Gurgel, Flavio" <flavio(at)4linux(dot)com(dot)br> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Matthew Wakeling <matthew(at)flymine(dot)org>, Lefteris <lsidir(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, Ivan Voras <ivoras(at)freebsd(dot)org> |
| Subject: | Re: Air-traffic benchmark |
| Date: | 2010-01-07 18:10:21 |
| Message-ID: | 21221819.49291262887821207.JavaMail.root@mail.4linux.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
----- "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolas Everett | 2010-01-07 18:11:15 | Re: Air-traffic benchmark |
| Previous Message | Scott Marlowe | 2010-01-07 18:02:13 | Re: Air-traffic benchmark |