[Spacewalk-list] Optimizing postgresql with Spacewalk 1.5 on CentOS 6.0 x86_64

[Gerald]

Hi,

well in fact it does! Now it takes ~8sec per pkg (imported 500pkg's), but performance is fast decreasing.

So at the moment the only way to import a large amount of packages is to start, kill,
restart postgres, restart spacewalk and start again, and again...?

Regards,
Gerald

-----Ursprüngliche Nachricht-----
Von: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Michael Mraka
Gesendet: Freitag, 23. September 2011 10:57
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Optimizing postgresql with Spacewalk 1.5 on CentOS 6.0 x86_64

Gerald wrote:
% Hi,
%
% I'm now syncing for TWO AND A HALF WEEK (spacewalk-repo-sync for centos5+6 % repos) % and still not finished (spacewalk 1.5 with postgresql, centos5 x86_64).
%
% Especially the larger repos from rpmforge are a massive problem.
% With oracle guess I synced all in max. 2 days.
%
% I've tried the performance settings from below, tried others, added more % ram, etc. but it still takes ages % % (at the moment I'm syncing package 6200 of 8215 and it takes 61sec per % package! In the beginning it's a bit faster and then % it gets slower and slower).
%
% Disabling taskomatic and osa-dispatcher didn't help either. Maybe there are % some other suggestions to try?
%
% Hope someone can speed up this process.

Don't postgresql restart help you?
http://www.redhat.com/archives/spacewalk-list/2011-September/msg00041.html

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list