On 07/10/2011 02:31 PM, Samuel Gendler wrote:
What about partitioning tables by tenant id and then maintaining
indexes on each partition independent of tenant id, since constraint
exclusion should handle filtering by tenant id for you. That seems
like a potentially more tolerable variant of
lars lhofha...@yahoo.com wrote:
We are maintaining a large multi tenant database where *all*
tables have a tenant-id and all indexes and PKs lead with the
tenant-id. Statistics and counts for the all other columns are
only really meaningful within the context of the tenant they
belong to.
I know this has been discussed various times...
We are maintaining a large multi tenant database where *all* tables have
a tenant-id and all indexes and PKs lead with the tenant-id.
Statistics and counts for the all other columns are only really
meaningful within the context of the tenant they
On Sun, Jul 10, 2011 at 2:16 PM, lars lhofha...@yahoo.com wrote:
I know this has been discussed various times...
We are maintaining a large multi tenant database where *all* tables have a
tenant-id and all indexes and PKs lead with the tenant-id.
Statistics and counts for the all other