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  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Fixed length data types issue  (Bruce Momjian <bruce@momjian.us>)
Re: Fixed length data types issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Bruce Momjian <bruce@momjian.us> 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
Дата:
Сообщение: Re: Fixed length data types issue