From: Gurgel, Flavio <flavio@4linux.com.br>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Matthew Wakeling <matthew@flymine.org>
Cc: Lefteris <lsidir@gmail.com>
Cc: pgsql-performance@postgresql.org, Ivan Voras <ivoras@freebsd.org>
Subject: Re: Air-traffic benchmark
Date: Thu, 7 Jan 2010 16:10:21 -0200 (BRST)
Message-ID: <21221819.49291262887821207.JavaMail.root@mail.4linux.com.br> (raw)
In-Reply-To: <dcc563d11001071002i38214570if8fcc738021116fe@mail.gmail.com>
----- "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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: flavio@4linux.com.br, scott.marlowe@gmail.com, matthew@flymine.org, lsidir@gmail.com, ivoras@freebsd.org
Subject: Re: Air-traffic benchmark
In-Reply-To: <21221819.49291262887821207.JavaMail.root@mail.4linux.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox