4 ms·
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
by jeltz 5y ago
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.
- spookthesunset 5y agoPostgres 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.