Re: Speed & Memory Management

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Speed & Memory Management
Дата
Msg-id 1049399269.13798.5329.camel@camel
обсуждение исходный текст
Ответ на Re: Speed & Memory Management  (Jodi Kanter <jkanter@virginia.edu>)
Список pgsql-admin
On Thu, 2003-04-03 at 13:22, Jodi Kanter wrote:
> In response to the speed and memory management messages posted. Can
> someone tell me if the varchar(N) data type also impedes performance by
> padding with spaces?
> Thank you,
> Jodi
>

Well no since varchar doesn't pad spaces. Theoretically this does make
it an improvement over char, although by this same theory it does have
to do length checks on the input strings, which would slow things down
versus text data types *in theory*.

Don't forget also that a varchar(30) will _prevent_ strings longer than
30 chars, not truncate them.

Robert Treat


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

Предыдущее
От: Kris Kiger
Дата:
Сообщение: Re: Speed & Memory Management
Следующее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: 7.2.3 -> 7.3.2: timeofday(), server crashed