Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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
In response to
pgsql-general by date
|Next:||From: Madison Kelly||Date: 2004-06-23 05:37:03|
|Subject: Re: Datatype sizes; a space and speed issue?|
|Previous:||From: Tom Lane||Date: 2004-06-23 05:01:50|
|Subject: Re: Parameters from trigger to function. |