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

[Michael Mraka]

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