Re: char() or varchar() for frequently used column - Mailing list pgsql-novice

Jules,

> Are there any flaws in this approach? Will I get in trouble when
> using
> indexes. Will performance be hampered severely? (we're not talking
> about huge amounts of transactions)

On postgresql, there is no performance difference between CHAR and
VARCHAR.   And a VARCHAR(25) which only has 1 character in each row is
no slower than a VARCHAR(2) that has only one character.

-Josh Berkus