Re: Range Types, discrete and/or continuous

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Range Types, discrete and/or continuous
Дата
Msg-id 1288051990.10835.16.camel@jdavis-ux.asterdata.local
обсуждение исходный текст
Ответ на Re: Range Types, discrete and/or continuous  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Range Types, discrete and/or continuous  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Mon, 2010-10-25 at 18:03 -0400, Robert Haas wrote:
> Hmm.  Do you have some concrete examples of cases where a range type
> might want to do some representational optimization?

Let's say for instance you want to keep an timestamp range in 16 bytes.
You could have an 8-byte timestamp, a 7-byte integer that represents the
offset from that timestamp in microseconds, and one byte for flags (e.g.
NULL or infinite boundaries, etc.). I'm not sure that you can make that
representation work in a generic way.

It's not critical, and perhaps not even desirable. But it crossed my
mind because alignment might make a 17-byte type look like 24 bytes,
which seems pretty wasteful to me.

Regards,Jeff Davis




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Range Types, discrete and/or continuous
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: foreign keys for array/period contains relationships