Hello, I found Solidus and once again I was surpri...
# general
a
Hello, I found Solidus and once again I was surprised by the great Ruby on Rails community. Thank you for developing something this nice! I am a Rails Developer and a Young Entrepreneur - starting an Online Marketplace business. I am using Solidus as our base Ecommerce application. We want to allow for our clients to open their stores through our platform. For this we need a Multi-tenant architecture. I have a question for the community: I am trying to achieve a Multi-Tenant Marketplace, and most people mentioned the Apartment gem. I read that Postgresql had recorded issues with this where in cases where more than 50 vendors were registered, the database crashed. Is there any architectural advice about a software like this? Any case of an application similar to this that I can base to? Maybe some Solidus cases similar? Anything is helpful.
k
I don’t have experience with such a huge marketplace, but what I can say by experience is that having 50 clients is a good problem to have and at that point you can probably invest in improving the architecture to fix all the problems you can have.
🙌 1
b
Tenants and the creation of tables can take up quite a bit of memory. I would assume each 100 some odd tables being created would use up a lot of RAM.
Your other options are to partition tables, use Citus, or just make new PG databases instead of schemas.
64kb are required to create a table. That means each schema might be around 6MB in size.
6*50 = 300MB
Depending on how large the sample is, you can experience some issues during growth. Especially with users that just sign up for the free trial and then drop out.
1