'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

On Saturday 14 August 2004 01:01 pm, CSN wrote:[color=blue]
> '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?
>[/color]

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

--
Robert C. Paulsen, Jr.
robert@paulsenonline.net

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