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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
