> Actually, the index returns page numbers in the table on disc which
> may contain one or more rows that are relevant. Postgres has to fetch
> the whole row to find out the email_id and any other information,
> including whether the row is visible in your current transaction
> (concurrency control complicates it all). Just having a page number
> isn't much use to you!
I learn something new every day.
In response to
pgsql-performance by date
|Next:||From: Lionel||Date: 2008-06-17 13:38:59|
|Subject: Which hardware ?|
|Previous:||From: Matthew Wakeling||Date: 2008-06-17 13:23:00|
|Subject: Re: [PERFORM] Migration Articles.. ???|