News for hackers. Stuff that matters.

A comment on Multi-Tenant Architectures. Parent comment

Re:Multi-Tenant Architectures by ccleve on Sunday August 30, 2020 @06:54PM (#24326693)
There's another benefit to using a tenant_id. You can partition your tables using Postgres partitioning. That keeps the tenant's data together and keeps queries fast.

It's also amenable to distributed processing if you use something like Citus.

I'm really looking for an alternative to Citus, though. Citus itself is a bit tricky to use, and the SaaS version of it is owned by Microsoft, which means Azure-only. Also, Microsoft makes the SaaS version insanely expensive. If they had Citus-like features on Amazon Aurora I'd be there in a heartbeat.

[ Parent | on HN ]
Re:Multi-Tenant Architectures by jaxn on Sunday August 30, 2020 @10:59PM (#24328131)
I use Citus. Their team is great, but it is very expensive.

The move from AWS to Azure came with a reduction of IOPS per instance. We have not had the same level of performance since migrating to Azure.

I am considering running our own Citus instances.

[ Parent | on HN ]