Does `AshPostgres` support partitions? i.e. Schema-based multitenancy
I checked the docs, but didn't see any reference to partitions.
When you use `global? True for schema-based multitenancy, what happens?
1. The global table is partitioned, and then use the tenant partitions for the query?
2. Is the data duplicated in the global and tenant tables? - It looks like this is what's occurring
Solution:Jump to solution
It creates a global table allowing you to have both tenanted and non tenanted data
3 Replies
Schema based multitenancy doesn't really support global
Solution
It creates a global table allowing you to have both tenanted and non tenanted data
But partitions aren't the same thing
Partitions are something you can manage yourself to split up your data a certain way for better perf characteristics