Rajesh Kumar Mallah wrote:
Hi ,
I noticed that an entry in pg_stat_activity was existing for a long duration > 2 mins while its backend ( process corresponding to that procpid) was not running.
how can it be possible ?
version: 7.3.4
There was a bug that caused a crashing backend to hang around in the stats until the slot is reused, because the message telling that the backend terminates is never sent to the collector daemon. I'm not sure if that got fixed for 7.4.
Thanks for explaining.
Regds Mallah.
Jan
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
