Recommended setup, autoscaling, and cost calculations for a Django and PostgreSQL web app

Hi everyone,

I’m developing a web application using Django and PostgreSQL. The app is mostly static, with some dynamic elements like a progress bar that updates based on user activity. Videos will be hosted on YouTube and embedded via iframes, so we don’t plan to upload large files directly to the server.

We’ve estimated the following for the initial launch:

  • PostgreSQL database: ~50 MB (expected to grow over time)
  • Static files (images, CSS, etc.): ~50 MB
  • Traffic: Around 10 to 50 users per hour, spending approximately 2 to 10 minutes on the site (with a rare peak of 100 users per hour)
  • Transactions: Between 27,000 and 54,000 for each event

For now, we’re considering:

  • 2 GB RAM
  • 1 or 2 vCPUs
  • 2 GB storage

I have a few questions:

  1. What would be the most suitable service setup on Render for this kind of project?
  2. How does autoscaling work exactly? If there’s a sudden traffic spike, do resources automatically adjust? How can we control costs to avoid unexpected overages?
  3. How are compute costs calculated? Is it based on actual usage, or does it depend on the allocated resources regardless of whether they are fully utilized?
  4. Would you recommend starting with a specific plan or a strategy to gradually scale as needed?

Any advice or insights would be greatly appreciated. Thanks!