Re: stats collector process high CPU utilization

От: Tom Lane
Тема: Re: stats collector process high CPU utilization
Дата: ,
Msg-id: 17817.1172789069@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: stats collector process high CPU utilization  ("Merlin Moncure")
Ответы: Re: stats collector process high CPU utilization  ("Merlin Moncure")
Список: pgsql-performance

Скрыть дерево обсуждения

stats collector process high CPU utilization  (Benjamin Minshall, )
 Re: stats collector process high CPU utilization  (Tom Lane, )
  Re: stats collector process high CPU utilization  (Benjamin Minshall, )
   Re: stats collector process high CPU utilization  (Tom Lane, )
    Re: stats collector process high CPU utilization  (Benjamin Minshall, )
     Re: stats collector process high CPU utilization  (Tom Lane, )
      Re: stats collector process high CPU utilization  (Benjamin Minshall, )
       Re: stats collector process high CPU utilization  (Tom Lane, )
        Re: stats collector process high CPU utilization  (Benjamin Minshall, )
         Re: stats collector process high CPU utilization  (Tom Lane, )
          Re: stats collector process high CPU utilization  (, )
           Re: stats collector process high CPU utilization  (Tom Lane, )
            Re: stats collector process high CPU utilization  (Alvaro Herrera, )
             Re: stats collector process high CPU utilization  (Tom Lane, )
              Re: stats collector process high CPU utilization  (Tom Lane, )
               Re: stats collector process high CPU utilization  (Benjamin Minshall, )
                Re: stats collector process high CPU utilization  (Tom Lane, )
                 Re: stats collector process high CPU utilization  (Benjamin Minshall, )
                  Re: stats collector process high CPU utilization  (Tom Lane, )
                   Re: stats collector process high CPU utilization  (Benjamin Minshall, )
                   Re: stats collector process high CPU utilization  ("Merlin Moncure", )
                    Re: stats collector process high CPU utilization  (Tom Lane, )
                     Re: stats collector process high CPU utilization  ("Merlin Moncure", )
                      Re: stats collector process high CPU utilization  (Tom Lane, )
                       Re: stats collector process high CPU utilization  (Magnus Hagander, )
                   Re: stats collector process high CPU utilization  (Bruce Momjian, )
                    Re: stats collector process high CPU utilization  ("Joshua D. Drake", )

"Merlin Moncure" <> writes:
> On 3/1/07, Tom Lane <> wrote:
>> A further report led us to realize that 8.2.x in fact has a nasty bug
>> here: the stats collector is supposed to dump its stats to a file at
>> most every 500 milliseconds, but the code was actually waiting only
>> 500 microseconds :-(.  The larger the stats file, the more obvious
>> this problem gets.

> I think this explains the trigger that was blowing up my FC4 box.

I dug in the archives a bit and couldn't find the report you're
referring to?

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Adam L Beberg
Дата:
Сообщение: Array indexes, GIN?
От: Josh Berkus
Дата:
Сообщение: Re: Array indexes, GIN?