Re: Why is my stats collector so busy?

От: Tom Lane
Тема: Re: Why is my stats collector so busy?
Дата: ,
Msg-id: 7975.1244653626@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Why is my stats collector so busy?  (Laszlo Nagy)
Список: pgsql-performance

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

Why is my stats collector so busy?  (Laszlo Nagy, )
 Re: Why is my stats collector so busy?  (Bruce Momjian, )
  Re: Why is my stats collector so busy?  (Merlin Moncure, )
   Re: Why is my stats collector so busy?  (Robert Schnabel, )
  Re: Why is my stats collector so busy?  (Laszlo Nagy, )
 Re: Why is my stats collector so busy?  (Tom Lane, )
  Re: Why is my stats collector so busy?  (Laszlo Nagy, )
   Re: Why is my stats collector so busy?  (Tom Lane, )

Laszlo Nagy <> writes:
> On a 8 processor system, my stats collector is always at 100% CPU.
> 8.3.5 on FreeBSD 7.0 amd64

Hmm.  How many tables in the installation?  Or perhaps more to the
point, how large is $PGDATA/global/pgstat.stat?  It might be that
it's just spending too much time dumping out that file.  There's
a fix for that planned for 8.4 ...

            regards, tom lane


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

От: David Kerr
Дата:
Сообщение: Re: Looking for installations with a large number of concurrent users
От: Dimitri Fontaine
Дата:
Сообщение: Re: Hosted servers with good DB disk performance?