[GENERAL] Postgresql and resource isolation

2007-11-15 Thread Garber, Mikhail
Hello, We are considering using Postgresql for rather large project and I have questions about where it stands in respect to the following. Consider these two features already found in major commercial products. A) "resource governor" - the ability to configure how much resources (IO per seco

Re: [GENERAL] Postgresql and resource isolation

2007-11-15 Thread Andrew Sullivan
On Thu, Nov 15, 2007 at 10:12:51AM -0800, Garber, Mikhail wrote: > > A) "resource governor" - the ability to configure how much resources (IO > per second, CPU slices) particular users or sessions are allowed to use PostgreSQL is not like several other commercial systems, in that it doesn't "tak

Re: [GENERAL] Postgresql and resource isolation

2007-11-15 Thread Joshua D. Drake
Trevor Talbot wrote: On 11/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: A) "resource governor" - the ability to configure how much resources (IO per second, CPU slices) particular users or sessions are allowed to use That is controlled from the operating system. What OSes support this

Re: [GENERAL] Postgresql and resource isolation

2007-11-15 Thread Trevor Talbot
On 11/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > A) "resource governor" - the ability to configure how much resources > > (IO per second, CPU slices) particular users or sessions are allowed > > to use > That is controlled from the operating system. What OSes support this? --

Re: [GENERAL] Postgresql and resource isolation

2007-11-15 Thread Trevor Talbot
On 11/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Well I know that FreeBSD through Jails and Linux through Xen can give > you fine grained control over how much resources a particular instance > can use. I hadn't seen the new limits in jail, the CPU limiting in particular is neat. I'm no

Re: [GENERAL] Postgresql and resource isolation

2007-11-16 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 15 Nov 2007 10:12:51 -0800 "Garber, Mikhail" <[EMAIL PROTECTED]> wrote: > > Hello, > > We are considering using Postgresql for rather large project and I > have questions about where it stands in respect to the following. > > Consider these