Re: index-only scans

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: index-only scans
Дата
Msg-id 4E444341.5070409@commandprompt.com
обсуждение исходный текст
Ответ на Re: index-only scans  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список 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 по дате отправления:

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: index-only scans
Следующее
От: Robert Haas
Дата:
Сообщение: Re: index-only scans