| Sounds like your postgresql server may need to be tuned. Probably you are exceeding one of the max working memory settings on some of the queries so it's swapping part of the query data to disk to execute the query. I recommend you have an experienced PostgreSQL DBA look at it an tune it for you, because tuning PostgreSQL for large queries is more of an art than science.
Hi,
I'm wondering if anybody has experienced slow lag accessing the Systems tab in the Web UI. We are using Oracle Linux 6.5 for our Spacewalk master with the Oracle Spacewalk 2.2 release. We have multiple Spacewalk proxies, each will manage 1k instances up to a total of 6 proxies. We have a separate Oracle db server running 11G R2. What we are seeing is a long lag when accessing the Systems Overview page. We've tried all the standard tuning for Java and tomcat, all the recommended tuning for Spacewalk and Satellite configurations with no change. When we have 100 OL instances registered it takes 5 sec flicking between Overview and the Systems tab. When we increase this to 350 OL instances we see the lag jump to 15 secs, then increasing up to 1100 OL instances this lag is up to 70 secs. This is not going to be workable when we start increasing to +5k instances. Thanks in advance Andy | ||
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
