Re: [ADMIN] possibly outdated info in pg_stat_activity

2005-10-17 Thread Alvaro Herrera
Rajesh Kumar Mallah wrote: > PID 3533 does not exists in the system but its still in pg_stat_activity. > This is PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc > (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-49). This is normal behavior. Sometimes the packets used to update the stat col

[ADMIN] possibly outdated info in pg_stat_activity

2005-10-16 Thread Rajesh Kumar Mallah
Hi, PID 3533 does not exists in the system but its still in pg_stat_activity. This is PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-49). Not sure if its already known issue , advance apologies if so. tradein_clients=# SELECT procpid,query_st