How can I improve a simple join on a very small table? (postgres)
This is the best index

CREATE INDEX ON cars (color, year);


Make sure that you have correct statistics, particularly on the small table:

ANALYZE make_model;
ANALYZE cars;