On Friday 02 of November 2012 15:41:25 Johannes Renner wrote: > On 10/31/2012 05:00 PM, Tomas Lestach wrote: > > On Wednesday 31 of October 2012 14:38:49 Johannes Renner wrote: > >> Hey, > >> > >> Ok, here is the patch to make the rewritten query work with PG as well > >> (API > >> call 'system.listLatestUpgradablePackages'). It's actually a follow up to > >> this commit: > >> > >> 4823565b2e634bc73010d366ff82c432630bca85 > > > > Committed as: 594781171402e28f85cdcb9fe7e838e35288a505 > > > >> It was strange though when testing it: for most of my systems it returned > >> really quick (with 0 results though), but I also had one system, where > >> the > >> query did not return at all, even after 1 hour! You might want to do some > >> additional performance testing here. There was nothing special about this > >> specific host though, it was even subscribed to a base channel only.. > > > > Can you still reproduce it with that system? > > I could reproduce it until I cherry-picked your most recent fix from master: > > 1168f61a9d16b42b533a21513c8538529862e745 > > The fixed query now runs reasonably fast and delivers results immediately > for that specific system. So I'd consider this issue as fixed.
Thank you, -- Tomas Lestach RHN Satellite Engineering > > Thanks, > Johannes _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel