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. Thanks, Johannes -- SUSE LINUX Products GmbH, HRB 16746 (AG Nürnberg) GF: Jeff Hawn, Jennifer Guild, Felix Imendörffer _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
