[Spacewalk-list] Postgres connection issues with Spacewalk 1.9

[Coffman, Anthony J]

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: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Wednesday, March 13, 2013 4:27 AM
To: spacewalk-list at redhat.com
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
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list