CHAR vs VARCHAR
От | Derek Neighbors |
---|---|
Тема | CHAR vs VARCHAR |
Дата | |
Msg-id | Pine.LNX.4.10.10102261238420.18535-100000@www.llamacom.com обсуждение исходный текст |
Ответы |
Re: CHAR vs VARCHAR
|
Список | pgsql-admin |
I browsed the FAQ and mailing list briefly to try to garner information about the ups and downs of different character based datatypes. I did not see any good document on preference or when to use one over the other. http://postgresql.readysetnet.com/docs/faq-english.html#4.15 noted that some compression happens. http://postgresql.readysetnet.com/users-lounge/docs/7.0/user/datatype1066.htm gives a good description and notes that text is best choice, but it not being SQL compliant is an issue for most. The question is how much of speed difference is there between CHAR and VARCHAR when doing searches etc? or are there any good rules others use to determine when CHAR is better to use than VARCHAR or vice versa? Derek Neighbors GNU Enterprise http://www.gnue.org derek@gnue.org
В списке pgsql-admin по дате отправления: