idle processes

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: idle processes
Date: 2004-08-14 18:01:53
Message-ID: 20040814180153.24119.qmail@web52903.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

'ps axu' shows:

postgres 1249 0.0 0.7 20200 7296 ? S
11:50 0:00 postgres: user1 database1 127.0.0.1 idle
postgres 1251 0.0 0.6 20196 7036 ? S
11:50 0:00 postgres: user1 database1 127.0.0.1 idle
postgres 1264 0.0 0.3 19936 3200 ? S
11:50 0:00 postgres: user1 database1 127.0.0.1 idle
postgres 1267 0.0 0.2 19936 2992 ? S
11:50 0:00 postgres: user1 database1 127.0.0.1 idle
postgres 1274 0.0 0.2 19936 2996 ? S
11:50 0:00 postgres: user1 database1 127.0.0.1 idle
postgres 1275 0.0 0.2 19936 3000 ? S
11:50 0:00 postgres: user1 database1 127.0.0.1 idle

Any idea why these processes are hanging around (for
about 20 minutes)? There's not any other query hogging
that database. Will they eventually timeout?

(PostgreSQL) 7.4.1


__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-08-14 18:02:36 Re: Web application: Programming language/Framework
Previous Message Chris Travers 2004-08-14 17:58:11 Re: Web application: Programming language/Framework