Re:Old, Good Database Design
by dkersten on Tuesday September 15, 2020 @12:03PM
(#24482829)
Yeah, in fact, Postgres encourages the use of TEXT over VARCHAR. The documentation even states:
There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column.
There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column.
https://www.postgresql.org/docs/current/datatype-character.h...