Re: stats collector appears to be dying

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: stats collector appears to be dying
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE476988@algol.sollentuna.se
обсуждение исходный текст
Ответ на stats collector appears to be dying  (Shelby Cain <alyandon@yahoo.com>)
Ответы Re: stats collector appears to be dying  (Shelby Cain <alyandon@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Jason Earl
Дата:
Сообщение: Re: Help with tools...
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: maximum size