[Spacewalk-list] [Spacewalk 2.3] Postgres multithreading

[Bosch, Fabian (BITBW)]

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.bosch at bitbw.bwl.de<mailto:fabian.bosch at bitbw.bwl.de>
Internet: www.bitbw.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150807/c8efcd3f/attachment.htm>