idle processes

[CSN]

'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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Robert Paulsen]

On Saturday 14 August 2004 01:01 pm, CSN wrote:

'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?

Are you using persistant connections? For example, with PHP are you using
pg_pconnect instead of pg_connect?

--
Robert C. Paulsen, Jr.
ro****@paulsenonline.net

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org