Chris Browne <[EMAIL PROTECTED]> writes:
> We're getting a bit of an anomaly relating to pg_stat_activity...
> ...
> That PID has been dead for several days, but this connection is marked
> as being open, still, after lo many days.
This probably just means that the "backend termination" stats message
got dropped due to heavy load. That's expected behavior in all pre-8.2
releases: the stats system was never intended to provide
guaranteed-exactly-correct status. PG 8.2 has reimplemented the
pg_stat_activity view to make it more trustworthy. (The other stuff is
still probabilistic, but being just event counters, message loss isn't
so obvious.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
