Re: No heap lookups on index - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: No heap lookups on index
Date
Msg-id 1137710833.3069.89.camel@localhost.localdomain
Whole thread Raw
In response to Re: No heap lookups on index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 2006-01-18 at 20:13 -0500, Tom Lane wrote:

> Come to think of it, the idea also seems to map nicely into bitmap index
> scans: the index will directly hand back a list of potential pages to
> look at, but they are all marked "lossy" because the index doesn't know
> exactly which tuple(s) on the target pages match the query.  The
> existing bitmap-heap-scan code can take it from there.

Yes, I've privately suggested this solution in that context.

I think there is enough meat there to make this topic worth discussing
further, but not on list again just yet.

Best Regards, Simon Riggs




pgsql-hackers by date:

Previous
From: Andrew - Supernews
Date:
Subject: Bug: random() can return 1.0
Next
From: Thomas Hallgren
Date:
Subject: PostgreSQL and shared memory.