Re: stats collector process high CPU utilization

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: stats collector process high CPU utilization
Дата
Msg-id 14668.1170995218@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: stats collector process high CPU utilization  (minshall@intellicon.biz)
Ответы Re: stats collector process high CPU utilization  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
minshall@intellicon.biz writes:
> While exploring this problem, I've noticed that one of the frequent insert
> processes creates a few temporary tables to do post-processing.  Is it
> possible that the stats collector is getting bloated with stats from these
> short-lived temporary tables?  During periods of high activity it could be
> creating temporary tables as often as two per second.

Hmmm ... that's an interesting point, but offhand I don't see why it'd
cause more of a problem in 8.2 than 8.1.  Alvaro, any thoughts?

            regards, tom lane

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

Предыдущее
От: minshall@intellicon.biz
Дата:
Сообщение: Re: stats collector process high CPU utilization
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: stats collector process high CPU utilization