Re:Common mistakes in PostgreSQL
by brobdingnagians on Friday May 03, 2019 @09:13AM
(#19818077)
Yeah, I used to do the same thing, I had dozens of limited VARCHAR fields and sometimes I forgot to change them when my application validation logic changed, and then we'd get errors from length limits being hit. It was a very liberating day when I realized I didn't need to have the length limits in database and that it made no performance impact, I went through and removed them all promptly. Life has been better since.
[ Parent
| on HN ]
There are no comments on this comment yet.