idle processes - Mailing list pgsql-general

From CSN
Subject idle processes
Date
Msg-id 20040814180153.24119.qmail@web52903.mail.yahoo.com
Whole thread Raw
Responses Re: idle processes  (Robert Paulsen <robert@paulsenonline.net>)
List 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

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Web application: Programming language/Framework
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Web application: Programming language/Framework