Re: No heap lookups on index
Jim Nasby <jnasby@pervasive.com>
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: "Jonah H. Harris" <jonah.harris@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, David Scott <davids@apptechsys.com>, pgsql-hackers@postgresql.org
Date: 2006-01-18T22:38:53Z
Lists: pgsql-hackers, pgsql-general
On Wed, Jan 18, 2006 at 04:02:45PM -0500, Jonah H. Harris wrote: > David, > > You can find some of this discussion in "Much Ado About COUNT(*)". Related > to that discussion, I had written a patch which added visibility information > to the indexes. > > If you're interested in the patch and/or consulting, contact me offline. Does the patch change all indexes across the board? Do you have any performance numbers? I suspect that in some situations storing visibility info in the index would be a big win; if that's the case it would be very good if there was an option that allowed it. Perhaps this could be done using a different index access method... -- 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