[Spacewalk-list] database usage - size - io performance - repo sync - repo re-sync update times

[Stephen Herr]

On 07/28/2014 10:20 AM, Michael Mraka wrote:
> Kevin Abbey wrote:
> % Hi,
> %
> % I've installed spacewalk 2.2 and used the util script to create
> % channels.  I completed one repo sync for fedoa 20 updates which took
> % 1 day and 9 hours.  I noticed that the iowait was ~4 - 6% the entire
> % time.  When complete the db files or postgres were ~3GB.
> %
> %
> % *Questions*
> %
> % 1.  Will the sync take this long each time or only the 1st initial
> % sync?  It is not clear to me how much io will be repeated during an
> % update sync.
>
> Hi Kevin,
>
> It will download only newly discovered packages next time so it will be
> much faster.

In addition to that, this is a known problem that occurs only on the 
initial sync and should be fixed (or made much better) in Spacewalk 2.3. 
See https://bugzilla.redhat.com/show_bug.cgi?id=1023557

-Stephen