Description of problem: The time required for a Satellite 5.8 ISS slave to synchronise content has grown by an order of magnitude vs Satellite 5.7. Version-Release number of selected component (if applicable): spacewalk-backend-tools-2.5.3-177.el6sat.noarch How reproducible: Always Steps to Reproduce: 1. On a Satellite 5.7 which is a ISS slave, run satellite-sync and measure time taken to complete the sync 2. Upgrade said ISS slave Satellite 5.7 to Satellite 5.8 3. Re-run same satellite-sync command in step 1 and measure time taken to complete the sync 3. Actual results: Best case scneario is sync time doubling, worst case scenario is sync time taking many more times on a 5.8 ISS slave than on a 5.7. Expected results: Sync times remain comparable. Additional info: Steps "diffing" and "Linking packages to channels" seem to account for most of the increase in sync time.
Despite VACUUM was already executed after the upgrade to Satellite 5.8, running VACUUM again, this time with ANALYZE, brought the synchronization times back to what they were before the upgrade to Satellite 5.8.