3 ms·
Aggregating all tenants into the same tables could provide you with much more robust statistics for the query planner to use. There are also advantages from a
by bob1029 1y ago
Aggregating all tenants into the same tables could provide you with much more robust statistics for the query planner to use.
There are also advantages from a cache utilization standpoint if the system is heavily loaded.
- jandrewrogers 1y agoHaving tenants in the same tables is compatible with their data being on separate pages.
- bob1029 1y agoI am arguing for the I/O benefit of sharing pages between tenants. I understand there are potential regulatory concerns with this, but I've never seen an audit get even remotely close to this level of detail.