Re: Stale entries in pg_stat_activity

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 <mike@fuhr.org> 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/