...

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема ...
Дата
Msg-id 20020704120156.Q4321-100000@zoraida.natserv.net
обсуждение исходный текст
Ответы Re:  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re:  (Tom Lane <tgl@sss.pgh.pa.us>)
Re:  (strange@nsk.yi.org)
Re:  (Manfred Koizar <mkoi-pg@aon.at>)
Список pgsql-general
On the FAQ we have:

CHAR() is best when storing strings that are usually the
same length.  VARCHAR() is best when storing variable-length strings,
but you want to limit how long a string can be.  TEXT is for strings
of unlimited length, maximum 1 gigabyte.  BYTEA is for storing
binary data, particularly values that include NULL bytes.


How much space does "NULL" takes on a varchar.
I have a table where possibly less than 40% of the records will have a
value. I am wondering if I should go with a second table for those that
have the values or if NULL is small enough that it won't be much an
overhead for the possibly 60% instances when the column would be empty.




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

Предыдущее
От: Frank Joerdens
Дата:
Сообщение: Re: uploading texts
Следующее
От: Tom Lane
Дата:
Сообщение: Re: query problem in 7.2.1: serious planner issue