>If all you are doing is reading single rows from a single table using an index, then yes Postgres is overkill and other solutions may perform better

Honest question... Why someone with this usage would use a RDBMS?

Would be a poor choice IMHO.