Re: outdated (bad) information in pg_stat_activity

Jim Nasby wrote:

> > I too have had issues with "stuck" entries in the pg_stat_activity view -- > the real pid is long gone but postgres still thinks the process is there.
> >
> > It would be real sweet to have a way of cleaning this table with bringing > postgres off-line.
>
> Rather than trying to clean things up by hand, could the stats system
> instead periodically check to make sure that all the PIDs it knows about
> actually still exist? I think that should be a pretty cheap check to
> perform...

This would certainly work for me, even as a function that a DBA might call manually.
<...>
> On a side note, is GlobeXplorer using PostgreSQL? Would they be willing
> to let us publicize that fact? Better yet, would they be willing to do a
> case study?

We are indeed using postgres (and postGIS) for both runtime data access and billing and other misc. data processing requirements.

We're be delighted to be publicized as happy users -- the transition from Informix was fairly smooth and performance is solid.

Feel free to contact me off-list if you like for more substantive comments. I am gsw @ globexplorer.com

Greg W.