Re: [PERFORM] Effects of IDLE processes

2005-02-21 Thread Gaetano Mendola
Christopher Browne wrote: > After a long battle with technology, Gaetano Mendola <[EMAIL PROTECTED]>, an > earthling, wrote: > >>JM wrote: >> >>>Hi ALL, >>> >>> I was wondering if there is a DB performance reduction if >>>there are a lot of IDLE processes. >>> >>>30786 ?S 0:00 po

Re: [PERFORM] Effects of IDLE processes

2005-02-20 Thread Christopher Browne
After a long battle with technology, Gaetano Mendola <[EMAIL PROTECTED]>, an earthling, wrote: > JM wrote: >> Hi ALL, >> >> I was wondering if there is a DB performance reduction if >> there are a lot of IDLE processes. >> >> 30786 ?S 0:00 postgres: user1 gmadb 10.10.10.1 idle

Re: [PERFORM] Effects of IDLE processes

2005-02-20 Thread Gaetano Mendola
JM wrote: > Hi ALL, > > I was wondering if there is a DB performance reduction if there are a > lot of > IDLE processes. > > 30786 ?S 0:00 postgres: user1 gmadb 10.10.10.1 idle > 32504 ?S 0:00 postgres: user1 gmadb 10.10.10.1 idle > 32596 ?S 0:00 pos

Re: [PERFORM] Effects of IDLE processes

2005-02-18 Thread Tom Lane
JM <[EMAIL PROTECTED]> writes: > I was wondering if there is a DB performance reduction if there are a > lot of > IDLE processes. There will be some overhead, but I dunno if anyone's ever tried to measure it. regards, tom lane ---(end of br