Re: Faster data type for one-length values

André Volpato wrote:

> The ammount of space saved seems pretty clear to me.

Yeah, zero most of the time due to alignment.

> What are you saying is that the index behaviour is the same, for all
> types smaller than 4 bytes ?  For query performance, in a search is
> based on that standalone indexed field, would be any difference using :
>
> a. char(1) ;  b. int2;  c. "char"

char(1) takes at least five bytes (more if the char is multibyte), so it
would be slower than the other two, ceteris paribus.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support