There's actually quite a few ways to do shared database multi-tenant setups with pgvector. You can have separate out tenants into separate tables, schema, and even logical databases within the same database service itself.
Here's an overview of the methods [1] (all except separate database of course)
Here's an overview of the methods [1] (all except separate database of course)
[1]: https://x.com/avthars/status/1832915959406842241