The 15 seconds start up time limits the utility for production workloads indeed, specifically for multi-tenant apps looking to provide very strong per-tenant isolation. If you need Instant Postgres, check out Neon: https://neon.tech/demos/instant-postgres.

> If user-initiated connections are open, the instance doesn’t automatically pause