pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?
3+ messages / 2 participants
[nested] [flat]

* Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?
@ 2011-08-07 15:43 Ivan Sergio Borgonovo <mail@webthatworks.it>
  2011-08-07 21:38 ` Re: Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.? Craig Ringer <ringerc@ringerc.id.au>
  0 siblings, 1 reply; 3+ messages in thread

From: Ivan Sergio Borgonovo @ 2011-08-07 15:43 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringer <ringerc@ringerc.id.au> wrote:

> By the way, one of the reasons you're not finding much free
> hosting for PostgreSQL is that it takes a fair bit of work to run
> Pg multi-tenanted. Your additional requirement for Java and Tomcat

Why should pg be harder than anything else?


-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?
  2011-08-07 15:43 Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.? Ivan Sergio Borgonovo <mail@webthatworks.it>
@ 2011-08-07 21:38 ` Craig Ringer <ringerc@ringerc.id.au>
  2011-08-07 22:40   ` Re: Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.? Ivan Sergio Borgonovo <mail@webthatworks.it>
  0 siblings, 1 reply; 3+ messages in thread

From: Craig Ringer @ 2011-08-07 21:38 UTC (permalink / raw)
  To: Ivan Sergio Borgonovo <mail@webthatworks.it>; +Cc: pgsql-general@postgresql.org

On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
> On Sun, 07 Aug 2011 20:41:27 +0800
> Craig Ringer<ringerc@ringerc.id.au>  wrote:
>
>> By the way, one of the reasons you're not finding much free
>> hosting for PostgreSQL is that it takes a fair bit of work to run
>> Pg multi-tenanted. Your additional requirement for Java and Tomcat
> Why should pg be harder than anything else?

Before I go on: I'm not running a hosting provider. Most of this is 
gathered from time on the lists, plus my own observations from using Pg 
in situations where I want to prevent different apps sharing a DB from 
affecting each other. Given that qualification:

Things that contribute to making it harder to offer multi-tenanted 
database hosting services with Pg include: The global catalogs, in 
particular global user lists; relatively limited options for automatic 
load limitation and prioritisation; difficulty of preventing certain 
classes of effective denial of service by authorized users; shared WAL 
making it harder to isolate load and limit one DB's effects on another; 
difficulties completely hiding users from each other; the need to tune 
autovacuum to make sure it keeps up with load; etc. In Pg, DBs in a 
cluster affect each other in various ways, but because of the 
pinned-in-RAM nature of shared_buffers its hard to run one cluster per 
user as would be ideal.

This doesn't mean you can't use Pg for multi-tenanted DB hosting. It 
just makes it harder, and means its more sysadmin work, therefore more 
time and cost.

There are DBs - mostly $OMFGLOTS DBs - that offer much greater 
facilities for controlling access and isolating load than Pg does and 
are better suited to multi-tenanted use. Of course, their costs are such 
that it's probably cheaper to hire an army of sysadmins to run a giant 
cluster of Pg boxes instead...

--
Craig Ringer



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.?
  2011-08-07 15:43 Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.? Ivan Sergio Borgonovo <mail@webthatworks.it>
  2011-08-07 21:38 ` Re: Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.? Craig Ringer <ringerc@ringerc.id.au>
@ 2011-08-07 22:40   ` Ivan Sergio Borgonovo <mail@webthatworks.it>
  0 siblings, 0 replies; 3+ messages in thread

From: Ivan Sergio Borgonovo @ 2011-08-07 22:40 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

On Mon, 08 Aug 2011 05:38:02 +0800
Craig Ringer <ringerc@ringerc.id.au> wrote:

> On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
> > On Sun, 07 Aug 2011 20:41:27 +0800
> > Craig Ringer<ringerc@ringerc.id.au>  wrote:
> >
> >> By the way, one of the reasons you're not finding much free
> >> hosting for PostgreSQL is that it takes a fair bit of work to
> >> run Pg multi-tenanted. Your additional requirement for Java and
> >> Tomcat
> > Why should pg be harder than anything else?

> There are DBs - mostly $OMFGLOTS DBs - that offer much greater 

OK. I forgot to specify "anything else in the same league" or
shortly open source.

Nice reading anyway, thanks.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2011-08-07 22:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-07 15:43 Pg multi-tenanted hard? was: FREE hosting platforms with PostgreSQL, Java SDK, Tomcat, ecc.? Ivan Sergio Borgonovo <mail@webthatworks.it>
2011-08-07 21:38 ` Craig Ringer <ringerc@ringerc.id.au>
2011-08-07 22:40   ` Ivan Sergio Borgonovo <mail@webthatworks.it>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox