2 years ago
Hi, I'd like to know what would be better to optimize costs in Railway since I'm paying around $40 per month, I don't see that as a lot but well, if I can reduce it, better then.
I have 15 projects. Each one named with the name of the company, and inside it has a Postgres database and a Strapi CMS connected to it.
These receive around 150k requests per month.
2 GB of ram should be enough (I think, lol) to handle that amount of requests (and usage in general), but around 10k requests per month is enough make a single project use 750 MB - 1.25GB of RAM, so I have 15 projects using ~1GB of RAM, which is expensive.
I'd like to ask if it'd be cheaper to create a single project, put there a single Postgres Database (using different schemas for each project), and put the 15 Strapi Admins there, connected to it. Is there any catch-ups for this implementation or something I should know?
If there isn't a clear response to this, and it's something I should try out, let me know! Thanks!
31 Replies
2 years ago
what's the average usage of those postgres instances? Strapi is a resource hungry service
2 years ago
is that from the current month?
2 years ago
get from a past month, there's a selector on the top of the page
2 years ago
it doesnt show the postgres usage :/
but ok, my point is that the postgres usage is so little (about 50mb~100mb) that it might not be worth it doing all of that work
2 years ago
yep, as I guessed
2 years ago
you would save about 7.5$ by doing all of that
2 years ago
if its worth it for you ok but IMO i would leave it as is
Actually I prefer to leave this the way it is now, this way is easier to separate costs by client. But I'm going to think about it. Thanks a lot @ThallesComH
2 years ago
well, you also lose redundancy in case your postgres instance goes down
2 years ago
and a redundant postgres instance might be more expensive
2 years ago
yep, unfortunately thats the price to pay for using Strapi
2 years ago
I didn't try much CMS out there due to project restrictions so dont trust 100% my recommendations
2 years ago
but i really liked payload, they seems to support Vercel so you could probably host for free
2 years ago
I saw this video of them in case you want to take a look
2 years ago
i would recommend that too but i don't know their resource usage so it might be the same as strapi
2 years ago
I had to ask a customer to add another replica to their directus install since it couldn't handle sub 100 req/s 🫤
I don't know what they were doing with it, but still.
2 years ago
which is extremely weird 'cause directus handles more than that
2 years ago
I know, so they must have been doing something heavy
2 years ago
its already solved 🙂