...
От | Francisco Reyes |
---|---|
Тема | ... |
Дата | |
Msg-id | 20020704120156.Q4321-100000@zoraida.natserv.net обсуждение исходный текст |
Ответы |
Re:
Re: Re: Re: |
Список | 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 по дате отправления: