[Spacewalk-list] Repo Sync speed problem

[Jan Pazdziora]

On Wed, Aug 17, 2011 at 09:18:25AM -0600, Jeremy Davis wrote:
> Hello All,
> 
> I have this issue with slowness but the index does exist. It is somewhat
> quick for repositories that only hve like 2 or 3 package but repositories
> that have more than 300 it takes a while to process new packages. Any ideas
> as to what might be the cause? Thank you for your time and have a great day!

You should find out if it's the database or something else where
most CPU time is spent, and if it's the database system, find out
which query it spends its cycles. Then get the execution (explain) plan
for the query and see if it could be made faster.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat