Re: Datatype sizes; a space and speed issue?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Datatype sizes; a space and speed issue?
Дата
Msg-id 27035.1087967510@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Datatype sizes; a space and speed issue?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: Datatype sizes; a space and speed issue?  (Joel Matthew <rees@ddcom.co.jp>)
Список pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> The difference you cite is for char(N) fields, which are always padded
> with blanks to fill the N chars.

And, again, that's N logical *characters*, not bytes.

We used to have some attempts at optimizing on the assumption that
char(n) fields were physically fixed-width, but we gave it up as a
bad job several major releases back ... it was never more than a
very marginal optimization anyway ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Parameters from trigger to function.
Следующее
От: Madison Kelly
Дата:
Сообщение: Re: Datatype sizes; a space and speed issue?