Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000 - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000
Date
Msg-id 20051007152417.GC8765@surnet.cl
Whole thread Raw
In response to Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-bugs
On Fri, Oct 07, 2005 at 11:19:25AM -0400, Jean-Pierre Pelletier wrote:

> Our only remaining PostgreSQL problem is with pg_stat_actitivity
> being unreliable and the statistics collector being restarted many times
> every day.

The stats collector (which mantains pg_stat_activity among other things)
uses an UDP socket to receive info from the backends, so if UDP
communication is crippled, it's going to be unreliable.  Maybe there are
too many lost packets.  I don't know what could cause it to die though
-- certainly not lost packets.  (The postmaster restarts it
automatically if it detects it's not running.)

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"Everybody understands Mickey Mouse. Few understand Hermann Hesse.
Hardly anybody understands Einstein. And nobody understands Emperor Norton."

pgsql-bugs by date:

Previous
From: "Jean-Pierre Pelletier"
Date:
Subject: Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000