4 ms·

I just took a look at the manual (version for 9.3 and 11) and saw no such recommendation for character or character varying types... seems like the manual shoul

I just took a look at the manual (version for 9.3 and 11) and saw no such recommendation for character or character varying types... seems like the manual should be agnostic to such choices outside of deprecation. It did mention that common assumptions of performance differences weren't real in the PostgreSQL implementation. I think you're thinking of the Wiki rather than the manual: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Text_storage https://wiki.postgresql.org/wiki/Don%27t_Do_This#Text_storag... I generally agree with the advice in this section of the Wiki, but recognize that it's more opinionated... and less authoritative... than the manual.

gmueckl 7y ago
I was indeed referring to the section on text types in the manual. But I admit that I somehow lumped char and varchar together in my head while reading that section a couple of days ago. So you shouldn't ever use char (and only char) unless you have very specific requirements. This means that yes, I didn't get it straight.