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