[Spacewalk-list] Spacewalk 1.7 CPU Maxed out by postgresql (8.4)

[Boyd, Robert]

Sometime this morning my spacewalk server pegged 100% on cpu utilization and has been staying there ever since.   I tried a reboot, and just for grins updated errata/packages on the server.   After rebooting it's still pegging the cpu usage with this process:

postgres  2888 77.7  1.3 470128 53708 ?        Rs   10:35  52:05 postgres: spaceuser spaceschema 127.0.0.1(46206) SELECT

I am able to use  the Spacewalk admin website without any problem other than a bit of slow response.
How can I discover what is causing this (and hopefully fix it)?

Robert Boyd
Sr System Engineer | Peoplefluent
p. 919-645-2972 | c. 919-306-4681
e. Robert.Boyd at peoplefluent.com
Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: Peoplefluent Blog<http://peoplefluent.com/resources/peoplefluent-blog>
Follow: @peoplefluent<http://twitter.com/peoplefluent> | Download: iPad App<http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8>
[cid:image005.jpg at 01CDED95.75AF5FB0]<http://www.peoplefluent.com/>
[cid:image006.jpg at 01CDED95.75AF5FB0]<http://www.peoplefluent.com/mobile-talent-management>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130108/13112b77/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 2395 bytes
Desc: image005.jpg
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130108/13112b77/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 3726 bytes
Desc: image006.jpg
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130108/13112b77/attachment-0001.jpg>