Jan, Thanks! This additional patch makes a huge difference.
I tested it with 250 osad clients running simultaneously and the peak connection count was about 115 and it still seems to drop quickly when activity ceases. Performance was noticeably better than it's been in a very long time. When I do additional runs after it warms up the numbers are even lower at ~60. I sincerely appreciate the help! You just saved me quite a bit of effort to roll back and validate 1.8 again. Regards, --Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jan Pazdziora Sent: Wednesday, March 13, 2013 4:27 AM To: [email protected] Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9 On Tue, Mar 12, 2013 at 05:52:46PM +0000, Coffman, Anthony J wrote: > I applied the patch and rebooted to start things from a clean slate. > > The patch doesn't seem to fix the issue. > > The Postgres DB idle connections are still rising to more than 1000 very > rapidly and staying high even after the Spacewalk client activity is halting. > > The one change I do notice is that they seem to decline very rapidly down to > about 300 after the Spacewalk client activity ends. Before the patch they > would stay higher even after the activity had stopped. > Alright, here's an additional patch: http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=650885cfb32d97ea93928fbc511a1c7f7935f10e -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
