If you don’t already have redis in your stack, stick with postgresql for now. You can always optimise later, but a proper machine (not a crappy public cloud VM with heavy throttled network storage) can handle a lot of SQL transactions before introducing redis is worth the effort.