4 format, links
source | link

According to PostgreSQL's docsPostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT.

Should I add an arbitrary length limit to a name or address column?

Edit: Not a dupe of Would index lookup be noticeably faster with char vs varchar when all values are 36 chars,:

I know the CHAR type is a relic of the past and I'm interested not only in performance but other other pros and cons like Erwin stated in his amazing answer.

According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT.

Should I add an arbitrary length limit to a name or address column?

Edit: Not a dupe of Would index lookup be noticeably faster with char vs varchar when all values are 36 chars, I know the CHAR type is a relic of the past and I'm interested not only in performance but other other pros and cons like Erwin stated in his amazing answer.

According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT.

Should I add an arbitrary length limit to a name or address column?

Edit: Not a dupe of:

I know the CHAR type is a relic of the past and I'm interested not only in performance but other pros and cons like Erwin stated in his amazing answer.

    Tweeted twitter.com/StackDBAs/status/979234241660809217
3 Explain why the question is not a dupe
source | link

According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT.

Should I add an arbitrary length limit to a name or address column?

Edit: Not a dupe of Would index lookup be noticeably faster with char vs varchar when all values are 36 chars, I know the CHAR type is a relic of the past and I'm interested not only in performance but other other pros and cons like Erwin stated in his amazing answer.

According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT.

Should I add an arbitrary length limit to a name or address column?

According to PostgreSQL's docs, there's no performance difference between VARCHAR, VARCHAR(n) and TEXT.

Should I add an arbitrary length limit to a name or address column?

Edit: Not a dupe of Would index lookup be noticeably faster with char vs varchar when all values are 36 chars, I know the CHAR type is a relic of the past and I'm interested not only in performance but other other pros and cons like Erwin stated in his amazing answer.

2 add tags
| link
1
source | link