On Sat, 21 Dec 2002, Sander Steffann wrote:

> Hi,
> 
> > On the other hand, in a shared hosting environment, I don't think
> > anyone would really like to have resource limits. What does it help
> > if your online shop stops working because too many people are
> > ordering stuff? IMHO it would be much more useful to have resource
> > usage accounting in that case, so that users can be charged for
> > added database usage.
> 
> I work for an ISP offering shared hosting, and I don't like the idea of
> resource limits at all. Probably two things will happen:
> - Applications/websites will break for no good reason
> - Customers will be complaining about how unreliable PostgreSQL is

The system I would design would resemble that in Oracle. That is, by
default a user has unlimited access to resources. If the admin chooses to
limit resources, then so be it. The reason I've been thinking about it is
some people I've been working with at universities have a problem with
students effectively DoSing shared installations to affect
assessment. This was something they had control over when they used Oracle
:-(.

Gavin


Sun, 22 Dec 2002 15:14:39 +1100 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Re: Resource management in 7.4 
Gavin Sherry <swm@linuxworld.com.au> writes:
> ... The reason I've been thinking about it is some people I've been
> working with at universities have a problem with students effectively
> DoSing shared installations to affect assessment. This was something
> they had control over when they used Oracle :-(.

And the students have access to the administrative installation exactly
why?

This is not Oracle: you are not paying a per-installation license.
Put the students on their own box, and you'll have a situation way
more secure than when you used Oracle ;-)

			regards, tom lane

Sat, 21 Dec 2002 23:31:56 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Resource management in 7.4 
On Sat, 21 Dec 2002, Tom Lane wrote:

> Gavin Sherry <swm@linuxworld.com.au> writes:
> > ... The reason I've been thinking about it is some people I've been
> > working with at universities have a problem with students effectively
> > DoSing shared installations to affect assessment. This was something
> > they had control over when they used Oracle :-(.
> 
> And the students have access to the administrative installation exactly
> why?

Should have made this clearer. Students had a shared system to prepare
assessments. Some students were DoSing Postgres so that other students
could not finish assignments. Yes: the students should run their own
installations, they should not need to have 100% uptime. But it didn't
happen like that. It got me thinking...

Gavin


Sun, 22 Dec 2002 17:01:19 +1100 (EST)
Gavin Sherry <swm@linuxworld.com.au>
Re: Resource management in 7.4 