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.
Watch video The Only External System You Need online without registration, duration hours minute second in high quality. This video was added by user CompSciGuy 23 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 51,917 once and liked it 2.1 thousand people.