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

From Joshua D. Drake
Subject Re: index-only scans
Date
Msg-id 4E444341.5070409@commandprompt.com
Whole thread Raw
In response to Re: index-only scans  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers
On 08/11/2011 01:57 PM, Greg Sabino Mullane wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
>> 1. The way that nodeIndexscan.c builds up the faux heap tuple is
>> perhaps susceptible to improvement.  I thought about building a
>> virtual tuple, but then what do I do with an OID column, if I have
>> one?  Or maybe this should be done some other way altogether.
>
> Maybe it's time to finally remove the been-deprecated-for-a-while OIDs?

As a user space option certainly. However they are also used to track 
system objects, I don't know that we need to get rid of them for that 
purpose. We just need to remove WITH/WITHOUT OIDS for user tables.

JD
-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579


pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: index-only scans
Next
From: Robert Haas
Date:
Subject: Re: index-only scans