468,272 Members | 2,036 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

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

Nov 23 '05 #1
1 2338
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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Vin Jovanovic | last post: by
16 posts views Thread by Kerry Neilson | last post: by
1 post views Thread by dbrown2 | last post: by
2 posts views Thread by Andy Harrison | last post: by
4 posts views Thread by Evan Smith | last post: by
15 posts views Thread by Dirk Reske | last post: by
3 posts views Thread by Jim G | last post: by
2 posts views Thread by statmatics | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.