A simple question about text fields

Поиск
Список
Период
Сортировка
От Martin Mueller
Тема A simple question about text fields
Дата
Msg-id A213AB92-F8BA-4585-98E5-D709FB3BD36B@northwestern.edu
обсуждение исходный текст
Ответы Re: A simple question about text fields  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Are there performance issues with the choice of 'text' vs. varchar and some character limit?  For instance, if I have a
tablewith ten million records and text fields that may range in length from 15 to 150, can I expect a measurable
improvementin response time for using varchar(150) or will text    do just or nearly as well. 
 

If the latter is the case, using text across the board is a simpler choice  
    


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Establishing a local connection to PostgreSQL 9.6 takes seconds
Следующее
От: Tom Lane
Дата:
Сообщение: Re: A simple question about text fields