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

From Jim C. Nasby
Subject Re: No heap lookups on index
Date
Msg-id 20060119225835.GM78403@pervasive.com
Whole thread Raw
In response to Re: No heap lookups on index  (Jeremy Drake <pgsql@jdrake.com>)
Responses Re: No heap lookups on index  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: No heap lookups on index  (Jeremy Drake <pgsql@jdrake.com>)
List pgsql-hackers
On Thu, Jan 19, 2006 at 02:50:39PM -0800, Jeremy Drake wrote:
> On Thu, 19 Jan 2006, Jim C. Nasby wrote:
> 
> > Do you still have that patch that folks could look at? ISTM that this
> > technique would be rather dependant on your actual workload, and as such
> > could result in a big win for certain types of queries.
...
> Feel free to do whatever with this, it's pretty fast for tables where
> seeks to validate tuples would hurt, but you do get back dead things...

How'd you then weed out the dead tuples?

Basically, numbers talk. If there were convincing numbers for something
that wasn't a corner-case that showed a marked improvement then there'd
be much more interest in getting this into the backend in some fashion.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: un-vacuum?
Next
From: "John"
Date:
Subject: questions about varlist and Query