Re: Performance issue with 8.2.3 - "C" application

Список
Период
Сортировка
От Tom Lane
Тема Re: Performance issue with 8.2.3 - "C" application
Дата
Msg-id 122.1185333906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance issue with 8.2.3 - "C" application  (Karl Denninger)
Ответы Re: Performance issue with 8.2.3 - "C" application  (Karl Denninger)
Список pgsql-performance
Дерево обсуждения
Performance issue with 8.2.3 - "C" application  (Karl Denninger, )
 Re: Performance issue with 8.2.3 - "C" application  (Tom Lane, )
  Re: Performance issue with 8.2.3 - "C" application  (Karl Denninger, )
   Re: Performance issue with 8.2.3 - "C" application  ("Merlin Moncure", )
    Re: Performance issue with 8.2.3 - "C" application  (Karl Denninger, )
     Re: Performance issue with 8.2.3 - "C" application  (Tom Lane, )
      Re: Performance issue with 8.2.3 - "C" application  (Karl Denninger, )
       Re: Performance issue with 8.2.3 - "C" application  (Karl Denninger, )
 Re: Performance issue with 8.2.3 - "C" application  (Nis Jørgensen, )
 Re: Performance issue with 8.2.3 - "C" application  (Gregory Stark, )
Karl Denninger <> writes:
> Hmmmmm..... now that's interesting.  Stats collector IS accumulating
> quite a bit of runtime..... me thinks its time to go grab 8.2.4.

I think Merlin might have nailed it --- the "stats collector bug" is
that it tries to write out the stats file way more often than it
should.  So any excessive userland CPU time you see is just the tip
of the iceberg compared to the system and I/O costs incurred.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Karl Denninger
Дата:
Сообщение: Re: Performance issue with 8.2.3 - "C" application
Следующее
От: Karl Denninger
Дата:
Сообщение: Re: Performance issue with 8.2.3 - "C" application