On Sat, Oct 16, 2004 at 10:30:12PM -0600, Michael Fuhr wrote: > On Sun, Oct 17, 2004 at 12:01:45AM -0400, Tom Lane wrote: > > Michael Fuhr <[EMAIL PROTECTED]> writes: > > > pg_stat_activity sometimes shows old connections that have already > > > terminated. > > > > Define "old"? There's a built-in delay of up to half a second (if > > memory serves) in the statistics views. > > Fourteen minutes and counting.
Two hours and counting. I've also reproduced the problem using pgbench against 8.0.0beta3 on FreeBSD 4.10-STABLE. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(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
