Re: [GENERAL] Multi-tenancy in Postgres

2011-06-29 Thread Emrul Islam
Thank you so far for your perspectives on this. I especially agree some of the things raised by Radoslaw and Rob. While it may not be common to come across a scenario where this type of approach fits, I would like to point out that this type of solution is built into some commercial DBMS solution

Re: [GENERAL] Multi-tenancy in Postgres

2011-06-29 Thread Radosław Smogura
On Tue, 28 Jun 2011 17:04:54 -0600, Rob Sargent wrote: On 06/28/2011 04:52 PM, Greg Smith wrote: On 06/28/2011 05:45 PM, Rob Sargent wrote: I think Greg might be forgetting that some of us don't always get to choose what we work on. I was in a shop that decided to go with multi-tenancy for re

Re: [GENERAL] Multi-tenancy in Postgres

2011-06-28 Thread Rob Sargent
On 06/28/2011 04:52 PM, Greg Smith wrote: > On 06/28/2011 05:45 PM, Rob Sargent wrote: >> I think Greg might be forgetting that some of us don't always get to >> choose what we work on. I was in a shop that decided to go with >> multi-tenancy for reason both technical and um, er envious. > > The

Re: [GENERAL] Multi-tenancy in Postgres

2011-06-28 Thread Greg Smith
On 06/28/2011 05:45 PM, Rob Sargent wrote: I think Greg might be forgetting that some of us don't always get to choose what we work on. I was in a shop that decided to go with multi-tenancy for reason both technical and um, er envious. There are certainly successful deployments of multi-tenant

Re: [GENERAL] Multi-tenancy in Postgres

2011-06-28 Thread Rob Sargent
I think Greg might be forgetting that some of us don't always get to choose what we work on. I was in a shop that decided to go with multi-tenancy for reason both technical and um, er envious. One schema to update versus n, for an example of the former. Amazon does it, for the other example. But

Re: [GENERAL] Multi-tenancy in Postgres

2011-06-28 Thread Greg Smith
Emrul Islam wrote: I've just read through a paper here: http://www.edbt.org/Proceedings/2011-Uppsala/papers/edbt/a12-schiller.pdf about multi-tenancy. They used Postgres for their work and while it is academic and would need further work I'm just wondering if anyone in the Postgres team is l

[GENERAL] Multi-tenancy in Postgres

2011-06-28 Thread Emrul Islam
Hello, I've just read through a paper here: http://www.edbt.org/Proceedings/2011-Uppsala/papers/edbt/a12-schiller.pdfabout multi-tenancy. They used Postgres for their work and while it is academic and would need further work I'm just wondering if anyone in the Postgres team is looking at implemen