Re: No heap lookups on index
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: David Scott <davids@apptechsys.com>, pgsql-hackers@postgresql.org
Date: 2006-01-19T22:47:13Z
Lists: pgsql-hackers, pgsql-general
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