I have a SaaS product where we have hundreds of customers in 1 single database. The current database is in MS SQL and we are transitioning to Postgres. The current MS SQL is about 160gb in size.
We are evaluating fly for this product and I wanted to see if there are any suggestions on the architecture for this type of setup on fly. Some of my questions include:
- Should we break out the database by each of our customers? We have hundreds, not thousands but still sounds like a lot to maintain. Maybe a hybrid approach of dividing customers for every 100 customers or something into a db.
- What are the cost per region for a db of this size?
- Can the multi-region handle this type of setup?
Any other recommendation would be great!