Are you sure it's postgres causing the issue? I run an oracle backend, but ran into similar performance issues when attempting actions on a few hundred systems at a time. I was able to get around this by tweaking some of the tomcat connector settings.. This works pretty well supporting 8000+ hosts.
/etc/tomcat6/server.xml <Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" URIEncoding="UTF-8" address="127.0.0.1" maxThreads="2048" maxKeepAliveRequests="1000"/> <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8" address="127.0.0.1" maxThreads="3000" backlog="200" minSpareThreads="2000"/> <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" URIEncoding="UTF-8" address="::1" maxThreads="3000" backlog="200" minSpareThreads="2000"/> On Fri, Aug 5, 2016 at 5:20 PM, Konstantin Raskoshnyi <[email protected]> wrote: > Hi Guys, > > Got this problem - We have around 700 hosts, and pretty powerful sp server > - 32cores, 64g of ram. > > When I push to install a package to > than 100 hosts , our sp is busted. > Looks like postgres in not multithreaded and it sucks all life out of the > server. I optimized postgres config but i doesn't help. > > Any cases how to manage a lot of machines with sp? > > Thanks > > _______________________________________________ > 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
