Re: Fixed length data types issue

Поиск
Список
Период
Сортировка
Искать
От
Gregory Stark
Тема
Re: Fixed length data types issue
Дата
Msg-id
871wqjtf21.fsf@stark.xeocode.com
Ответ на
Список
Дерево обсуждения
Re: Fixed length data types issue Andrew - Supernews <andrew+nonews@supernews.com>
Tom Lane  writes:

> Bruce Momjian  writes:
> > Tom Lane wrote:
> >> Either way, I think it would be interesting to consider
> >> 
> >> (a) length word either one or two bytes, not four.  You can't need more
> >> than 2 bytes for a datum that fits in a disk page ...
> 
> > That is an interesting observation, though could compressed inline
> > values exceed two bytes?
> 
> After expansion, perhaps, but it's the on-disk footprint that concerns
> us here.

I'm a bit confused by this and how it would be handled in your sketch. I
assumed we needed a bit pattern dedicated to 4-byte length headers because
even though it would never occur on disk it would be necessary to for the
uncompressed and/or detoasted data.

In your scheme what would PG_GETARG_TEXT() give you if the data was detoasted
to larger than 16k?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления
От: Kevin Brown
Дата:
Сообщение: Re: Foreign keys
От: Bruce Momjian
Дата:
FAQ