PostgreSQL on Small VPS — What Are Your Limits?

2GB RAM, single instance, Next.js + Prisma. Where do you cut corners: connection pool, indexes, autovacuum? I don't want overkill, but crashes are getting old.