> > If it's two zombies per minute, then I bet it's the stat
> collector and
> > stat bufferer. They are restarted by the postmaster if not
> found to
> > be running.
> That would make some sense, because the stat processes need
> to set up new sockets (for the pipe between them). The
> autovacuum theory didn't hold any water in my eyes because
> autovacuum doesn't create any new sockets.
> However, why two zombies? That would mean that the
> grandchild process started, which should mean that the pipe
> was already created ...
> Does Windows have any equivalent of strace whereby we could
> watch what's happening during stats process launch?
First of all, I won't be able to dig into this any more until next week
- sorry about that. But others are always free to :-)
There is no strace equivalent builtin, but you can get an addon from
fm. Don't put it on a production box permanently, though, it tends to
cause BSODs in some cases.
pgsql-hackers by date
|Next:||From: Tony Caduto||Date: 2005-09-30 15:20:34|
|Subject: Re: Found small issue with OUT params|
|Previous:||From: Tom Lane||Date: 2005-09-30 13:58:51|
|Subject: Re: Socket problem using beta2 on Windows-XP |