| From: | JM <jerome(at)gmanmi(dot)tv> |
|---|---|
| To: | "Pgsql-Performance (E-mail)" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Effects of IDLE processes |
| Date: | 2005-02-18 10:15:16 |
| Message-ID: | 200502181815.17000.jerome@gmanmi.tv |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 postgres: user1 gmadb 10.10.10.1 idle
1722 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
1724 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
3881 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
6332 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
6678 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
6700 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
6768 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
8544 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
8873 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
8986 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
9000 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
9010 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
9013 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
9016 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
9019 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
9020 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle
TIA,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steinar H. Gunderson | 2005-02-18 14:08:50 | Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin |
| Previous Message | Tom Lane | 2005-02-17 23:28:05 | Re: VACUUM ANALYZE slows down query |