I have a semi-large (around 30 million records) key/value list which I want to load into redis.
The data is stored in PostgreSQL (as master data) and we want to distribute this to clients for faster (local) lookups.
The keys are Belgium telephone numbers (national format, so strings between 9 and 10 digits). The values are 5 letter strings.
There would be a redis-server on each client (around 10 clients per customer). The full dump will distributed once or maybe twice a year, while the updates are between 100-1000 a day (only business days between 08:00 and 18:00).
Is this an efficient way to do this?
Side remark: if redis isn't the correct choice, other suggestions are also welcome.