Re: Datatype sizes; a space and speed issue? - Mailing list pgsql-general

From Tom Lane
Subject Re: Datatype sizes; a space and speed issue?
Date
Msg-id 27035.1087967510@sss.pgh.pa.us
Whole thread Raw
In response to Re: Datatype sizes; a space and speed issue?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: Datatype sizes; a space and speed issue?  (Joel Matthew <rees@ddcom.co.jp>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parameters from trigger to function.
Next
From: Madison Kelly
Date:
Subject: Re: Datatype sizes; a space and speed issue?