This is the ONLY Infrastructure You Ever Need
You are using Postgres wrong. It can be used to vastly simplify your web app architecture. Postgres can replace: Kafka, Redis, MongoDB and any other infrastructure you use. At least it will work for your use case, because you probably don’t have millions of users.