When is SMALLINT a better fit than INTEGER in PostgreSQL?
SMALLINT
INTEGER
When storing only true or false
When values stay within a smaller integer range and saving storage is useful
When storing variable-length text with no declared limit
When storing a date and time together with time-zone information