Hi, is there a way to get postgres divide a query into multiple threads? If one Spacewalk-Organisation selects a bunch of packages (~1000) from Default-orga which is owner of the source-channel (shared over a Trust), there is only one postgres-process and only one CPU-core is handling this request. In my case, that’s why the spacewalk-service freezes and needs to be restarted.
This doesn’t happen if you do it within the Channel-owner-organization. Procedure to reproduce: * Create Dist-Base-Repo with >10.000 packages link it to a Channel and share it (Trust) * Create another organisation and put it in the Trust. * Log in to the new orga * Create an “empty” Channel and try to add/copy packages from the Channel in the trust * Select few hundreds or all packages in the Channel [‘select all’] * Watch Postgres getting greedy and spacewalk-service/WebUI breaking down. Software: CentOS 7 Spacewalk v2.3 Postgres v9.2.13 Tomcat 7.0.42-8 Java 1.7.0_85 Regards, Fabian Bosch Referat 34 – Open Source IT Baden-Württemberg (BITBW) Krailenshaldenstraße 44 70469 Stuttgart Telefon: +49 711 8910-94476 Telefax: +49 711 8910-17575 E-Mail: fabian.bo...@bitbw.bwl.de<mailto:fabian.bo...@bitbw.bwl.de> Internet: www.bitbw.de
_______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
