Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?
Дата
Msg-id 20080630085832.GA10876@depesz.com
обсуждение исходный текст
Ответ на Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sun, Jun 29, 2008 at 05:13:59PM -0400, Bill Moran wrote:
> Use the kdump utility to convert the ktrace.out file to something usable.
> Something like "kdump > ktrace.txt" will probably get you what you want,
> assuming your ktrace file is ktrace.out.

ok. did it. in about 7 seconds, i got 250mb of ktrace.out.
ktrace.txt is 176 megabytes.
content of this is pretty simple:
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)

should i make the ktrace.txt available, or should i do something else to
help you ( i mean, the pg-hackers community) diagnose the issue?

Best regards,

depesz


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

Предыдущее
От: "Henry - Zen Search SA"
Дата:
Сообщение: "out of balance" result on select from suspected index corruption
Следующее
От: "A B"
Дата:
Сообщение: allowed variable names in functions?