On Wed, Dec 14, 2005 at 02:02:02PM -0800, Gregory S. Williamson wrote:
> I too have had issues with "stuck" entries in the pg_stat_activity view -- the real pid is long gone but postgres
stillthinks 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...
> Greg Williamson
> DBA
> GlobeXplorer LLC
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?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461