Re: stats collector appears to be dying - Mailing list pgsql-general

From Magnus Hagander
Subject Re: stats collector appears to be dying
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE476988@algol.sollentuna.se
Whole thread Raw
In response to stats collector appears to be dying  (Shelby Cain <alyandon@yahoo.com>)
Responses Re: stats collector appears to be dying  (Shelby Cain <alyandon@yahoo.com>)
List pgsql-general
> I'm having an issue with what appears to be the stats
> collector process dying on Postgresql 8.0.1 running on
> Windows XP w/sp1.
>
> I've enabled
> stats_command_string and stats_row_level in my config file.
> During bulk inserts the stats collector process appears to
> encounter some sort of problem and shuts
> down.   The end result is the log file being spammed
> with "FATAL" entries regarding the process.  I've attached a
> small excerpt from my log files.
>
> Any ideas as to what is going on?

This is a known problem on WIndows. THe stats processor sometimes falls
down under heavly load. And if you enable row-level-stats the load goes
up considerably - especially during bulk inserts.

//Magnus

pgsql-general by date:

Previous
From: Jason Earl
Date:
Subject: Re: Help with tools...
Next
From: Richard Huxton
Date:
Subject: Re: maximum size