Re: index-only scans - Mailing list pgsql-hackers

From Greg Stark
Subject Re: index-only scans
Date
Msg-id CAM-w4HP-T3TaCFGZuGX9FM7rgGWdoS4jiadd98tDg8X_7BV6hw@mail.gmail.com
Whole thread Raw
In response to Re: index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: index-only scans  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Oct 9, 2011 at 9:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> At the moment I'm leaning to approach #3, but I wonder if anyone has
> a different opinion or another idea altogether.
>

Would any of these make it more realistic to talk about the crazy
plans Heikki suggested like doing two index scans, doing the join
between the index tuples, and only then looking up the visibility
information and remaining columns for the tuple on the matching rows?

-- 
greg


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: index-only scans
Next
From: Tom Lane
Date:
Subject: Re: index-only scans