Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on How to Build a SaaS Application Block by Block. Parent comment
You could use Postgres's partial indexes. (basically an index scoped per tenant).
Your 'WHERE' clauses would need to include the field indexed by those partial indexes.
https://devcenter.heroku.com/articles/postgresql-indexes#par...
I have not thought more though this, but may be combining that with the PG 11s partitioning, would get me even closer to tenant-specific archiving/backup and other admin tasks beyond query.
There are no comments on this comment yet.
You could use Postgres's partial indexes. (basically an index scoped per tenant).
Your 'WHERE' clauses would need to include the field indexed by those partial indexes.
https://devcenter.heroku.com/articles/postgresql-indexes#par...
I have not thought more though this, but may be combining that with the PG 11s partitioning, would get me even closer to tenant-specific archiving/backup and other admin tasks beyond query.