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 <gandalf@shopzeus.com>)
Список pgsql-performance
Laszlo Nagy <gandalf@shopzeus.com> 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: GiST index performance
Следующее
От: David Kerr
Дата:
Сообщение: Re: Looking for installations with a large number of concurrent users