News for hackers. Stuff that matters.
Re:Why do database columns have a character length of 191? by jeltz on Monday May 17, 2021 @03:52PM (#27187610)
PostgreSQL is also row oriented but can store small text and blob (bytes) fields in the main table. PostgreSQL determines per value if it fits in the main table storage or not. This means that varchar and text are virtually identical.

This is done for all variably sized data types, including third party GIS polygons.

Re:Why do database columns have a character length of 191? by spookthesunset on Monday May 17, 2021 @05:19PM (#27188591)
Postgres always amazes me how well designed it is. It’s too bad MySQL has the brand recognition it does because Postgres is just far and away the better choice for almost everything.