Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Gavin Sherry
On Sat, 21 Dec 2002, Tom Lane wrote: > Gavin Sherry <[EMAIL PROTECTED]> 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

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> 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

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Gavin Sherry
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

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes: > It would be nice if there was a way to renice a connection. When it > comes to reporting it would be nice to have a handle for slowing a > backend down. > A patch for Linux would be quite easy ("SELECT nice_backend(int)") No

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Michael Paesold
Tom Lane <[EMAIL PROTECTED]> wrote: > Gavin Sherry <[EMAIL PROTECTED]> writes: > > I've been thinking about resource management and postgres. I want to > > develop a user profile system (a-la oracle) which allows a DBA to > > restrict/configure access to system resources. This would allow a DBA t

Re: [HACKERS] Resource management in 7.4

2002-12-21 Thread Hans-Jürgen Schönig
Personally I think that configuring things like that is definitely beyond the scope of an average administrator. However, there is one thing which would be useful for many applications: It would be nice if there was a way to renice a connection. When it comes to reporting it would be nice to ha

Re: [HACKERS] Resource management in 7.4

2002-12-20 Thread Tom Lane
Gavin Sherry <[EMAIL PROTECTED]> writes: > I've been thinking about resource management and postgres. I want to > develop a user profile system (a-la oracle) which allows a DBA to > restrict/configure access to system resources. This would allow a DBA to > configure how much CPU time can be used pe