Re: Text/Varchar performance...

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Text/Varchar performance...
Дата
Msg-id 20051005183441.GA32451@uio.no
обсуждение исходный текст
Ответ на Text/Varchar performance...  ("Cristian Prieto" <cristian@clickdiario.com>)
Список pgsql-performance
On Wed, Oct 05, 2005 at 12:21:35PM -0600, Cristian Prieto wrote:
> Hello, just a little question, It's preferable to use Text Fields or
> varchar(255) fields in a table? Are there any performance differences in the
> use of any of them?

They are essentially the same. Note that you can have varchar without length
(well, up to about a gigabyte or so after compression), and you can have
varchar with a length well above 255 (say, 100000).

/* Steinar */
--
Homepage: http://www.sesse.net/

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

Предыдущее
От: "Jeffrey W. Baker"
Дата:
Сообщение: Re: [HACKERS] A Better External Sort?
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Ultra-cheap NVRAM device