Re:Vertically Scaling PostgreSQL
by eropple on Wednesday March 20, 2019 @09:28AM
(#19441868)
Postgres keeps ENUM types in memory at all times. A join table is probably a slower option, all other things being equal. There are cases where it's worthwhile (dynamically expanding the values that would be in that enum, for example), but it's a tradeoff.
[ Parent
| on HN ]
There are no comments on this comment yet.