Serverless Postgres vs VPS+PgBouncer
Managed Postgres is the default answer for most teams. But the pricing model of serverless databases (Neon, Supabase) and managed instances (Amazon RDS) is built around compute that is billed continuously, while a self-hosted PostgreSQL on a VPS is a fixed monthly cost that does not grow with your load. At some point the curves cross. For a steady, always-on workload, a single VPS running PostgreSQL plus PgBouncer is often dramatically cheaper than a managed database of equivalent size. This is that comparison: the economics, the latency story, and a decision table to help you pick. The version hook matters: PG14 is at end of life Before the cost comparison, a note on versions, because it directly affects a self-hosted setup. …
Read more →