Should Redis store the data used by the search?

Question

Redis

I have about 50,000 locations (cities, countries, states) in the file format, they will be used by the user quite actively. A person will be able to search for the locations he needs through the search.
Should such data be sent to Redis or can it be written to the database (I use Postgresql)?

Answer 1

50 thousand is not so much, if you correctly build indexes, then there should not be a load on the database. Radish or memkesh can be used as a cache if needed.

Answer 2

It is possible to keep the N most popular locations from all requests ( LRU ) in the cache. If it is not in the cache, then look in Postgresql.