Re: Stats collector frozen? - Mailing list pgsql-general

From Jeremy Haile
Subject Re: Stats collector frozen?
Date
Msg-id 1169751169.8952.1171235437@webmail.messagingengine.com
Whole thread Raw
In response to Re: Stats collector frozen?  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
> Then just pick it up in Task Manager or Process Explorer or whatever and
> kill it off. Just make sure you pick the right process.

I mentioned earlier that killing off the collector didn't work - however
I was wrong.  I just wasn't giving it enough time.  If I kill the
"postgres.exe -forkcol" process, it does gets restarted, although
sometimes it takes a minute.

Since it only seems to update pgstat.stat once after restarting, I'd
need to kill it once-a-minute to keep my statistics up to date =)  So,
unfortunately it's not a great workaround to my problem.


Jeremy Haile

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Stats collector frozen?
Next
From: "Ted Byers"
Date:
Subject: Re: Problem with result ordering