[Spacewalk-list] Spacewalk/Postgresql database issues

[Jonathan Scott]

Good Morning All,

I've started having some rather odd issues with my Spacewalk install using
postgres. Every night, we do an errata load which typically consists of a
handful of RPMs if anything at all, but recently (and for no apparent
reason) the database has just started slowing down. This is causing
everything on the system to back up;  when I checked this morning, there
were 542 postgres processes in various states (idle, idle in transmission,
UPDATE waiting [which concerns me the most]), and 258 httpd processes.
Restarting the database seems to clear the issue up, but I cannot find
anything specific in the logs to tell me what is going on here. There are
no traceback emails or other forms of alerting coming from the application.

Any insight?

Thanks!
Jonathan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120817/65dd5f8f/attachment.htm>