Postgres joins against small tables are really really efficient. It wouldn't shock me if enums actually were implemented as tables.