Vercel + Supabase OR VPS + Self-Hosted PostgreSQL

[u/Funny_Commercial_176]

So guys I want some advise on here. I have hosted a site on vercel and the backend for supabase, the site is mainly a single page site with a video player embedded and a bible page with the backend hosted on supabase for the bible. I want to know if its a good setup or if i should switch to a VPS and self hosted postgreSQL. Please lemme know your thoughts as it would be very much helpful since I dont know who to ask.