Re: [GENERAL] Postgresql 8.3: stats collector process eat all CPU all time

2008-04-09 Thread Tom Lane
Maxim Boguk <[EMAIL PROTECTED]> writes: > ktrace/kdump this process show just one sequence: > 69360 postgres CALL poll(0x7fffd4e0,0x1,0x7d0) > 69360 postgres RET poll -1 errno 4 Interrupted system call > 69360 postgres CALL poll(0x7fffd4e0,0x1,0x7d0) > 69360 postgres RET poll

[GENERAL] Postgresql 8.3: stats collector process eat all CPU all time

2008-04-09 Thread Maxim Boguk
details: db version: postgres (PostgreSQL) 8.3.0 OS version: FreeBSD 7.0-RELEASE stats collector eating whole single CPU last week or so... TOP lookin like: PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND 69360 pgsql 1 1240 22380K 5548K CPU0 1 258.6H 99.0