A) key-value is MUCH simpler to implement than an RDBMS, code wise. It’s arguably more boring and less theoretical than indices on PG or foreign key constraints

B) there’s a lot of tricky stuff with indices on PG and you generally need a DB admin from day 1

C) your comment is probably more appropriate for either layered databases or new fangled stuff like time series or graph db’s etc