I'm going to make sure this stays specific and not flagged as too broad.
I'm putting together an approach to store data in Heroku. This data is relatively simple in nature - it's key/value pairs, where the key is a unique ID, and the value is JSON, somewhere around 50k lines long. The primary requirement is fast retrieval of the value (JSON), by the unique key.
I've heard of three data services that Heroku offers: Postgres, Redis, and Kafka. My specific question is: solely based on the criteria above (the nature of the data being key/value pairs with JSON as the value, and the quickest retrievel), is one of these data services a better choice than the others?
A few side notes - CDN is also being evaluated, but for the sake of keeping this question specific and not being closed, looking for input on Heroku here :) Also, the volume of data will be several million rows, so let's also exclude the possibility of storing this data in Salesforce as well