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 по дате сообщения:

От: Dave Page
Дата:
Сообщение: Re: Table Statistics with pgAdmin III
От: "Simon Riggs"
Дата:
Сообщение: Re: [pgsql-advocacy] 8.2 -> 8.3 performance numbers