text should be a blob field

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SARZ
Тема text should be a blob field
Дата
Msg-id 219F68D65015D011A8E000006F8590C6010A51F7@sdexcsrv1.sd.spardat.at
обсуждение исходный текст
Ответы Re: [HACKERS] text should be a blob field  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Of course a first mail after a release must have the earned praise:
Very nicely done, I like it all ;-)

Reading the TODO, I see 'Allow text, char(), and varchar() overhead to be
only 2 bytes, not 4 bytes'
While this is very good for char and varchar, text is not a candidate
since it is usually a blob datatype, without a length restriction (or a 2Gig
limit).

I think it should alternately read:
Allow varchar() overhead to be only 2 bytes
remove char() 4 byte overhead, use atttypmod instead
make text a blob datatype (maybe storing <= 8k row with tuple, >=8k in blob
tablespace)

What do you think ?
Andreas

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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: Re: [HACKERS] patches now that 6.3 has been released
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Lost a function overloading capability in v6.3