On Tue, 17 Jun 2008, Howard Cole wrote:
> They both appear to do a scan on the email table (Why?).
The indexes don't contain copies of the row data. They only contain
pointers to the rows in the table. So once the index has been consulted,
Postgres still needs to look at the table to fetch the actual rows. Of
course, it only needs to bother looking where the index points, and that
is the benefit of an index.
Matthew
--
I've run DOOM more in the last few days than I have the last few
months. I just love debugging ;-) -- Linus Torvalds