stats collector process high CPU utilization

Поиск
Список
Период
Сортировка
От Benjamin Minshall
Тема stats collector process high CPU utilization
Дата
Msg-id 45CB5441.1040707@intellicon.biz
обсуждение исходный текст
Ответы Re: stats collector process high CPU utilization  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Greetings,

Since upgrading to 8.2.3 yesterday, the stats collector process has had
very high CPU utilization; it is consuming roughly 80-90% of one CPU.
The server seems a lot more sluggish than it was before.  Is this normal
operation for 8.2 or something I should look into correcting?

stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = false

--
Benjamin Minshall <minshall@intellicon.biz>
Senior Developer -- Intellicon, Inc.

Вложения

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

Предыдущее
От: Mark Stosberg
Дата:
Сообщение: tip: faster sorting for proximity queries by using cube_distance()
Следующее
От: Mark Stosberg
Дата:
Сообщение: Re: Speed up this query