varchar(), text,char() overhead

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема varchar(), text,char() overhead
Дата
Msg-id 199801212129.QAA25848@candle.pha.pa.us
обсуждение исходный текст
Список pgsql-hackers
Do people want the overhead of char(), varchar(), and text to be reduced
from 4-bytes to 2-bytes.  We store the length in this overhead, but
since we have a size limit on tuple size, we can't have a field over 8k
in size anyway.  Even if we up that to 32k for 6.3, we still only use 2
bytes.

I have added it to the TODO list.  Most of the code already supports it
by using VARSIZE and VARDATA macros.  Once the structure size changes,
the macros change too.  The only issue is places where they take the
first four bytes of the variable-length type and cast it to an int32,
which will not work in this case.  We have to change this so it uses the
macros too.

--
Bruce Momjian
maillist@candle.pha.pa.us

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

Предыдущее
От: ocie@paracel.com
Дата:
Сообщение: Re: [HACKERS] Re: [QUESTIONS] Business cases
Следующее
От: darrenk@insightdist.com (Darren King)
Дата:
Сообщение: Re: [HACKERS] varchar(), text,char() overhead