Re: [Spacewalk-devel] Patch review for exportLib.py

2012-02-03 Thread Parsons, Aron
ime: 2.154 ms (12 rows) /aron -Original Message- From: Parsons, Aron Sent: Friday, February 03, 2012 12:25 PM To: 'jpazdzi...@redhat.com' Subject: Re: [Spacewalk-devel] Patch review for exportLib.py Jan, The lookup* change you mention is for a separate change in satellite-syn

Re: [Spacewalk-devel] Patch review for exportLib.py

2012-02-03 Thread Jan Pazdziora
On Fri, Feb 03, 2012 at 03:55:53PM +, Parsons, Aron wrote: > Can someone verify that this is a sound change? rhn-satellite-exporter is > extremely slow on PostgreSQL when getting the file checksums. This speeds it > up dramatically. > > It's the same issue we ran into with PostgreSQL doing

[Spacewalk-devel] Patch review for exportLib.py

2012-02-03 Thread Parsons, Aron
Can someone verify that this is a sound change? rhn-satellite-exporter is extremely slow on PostgreSQL when getting the file checksums. This speeds it up dramatically. It's the same issue we ran into with PostgreSQL doing a left join on rhnChecksumView in 'query_client_get_file'. PostgreSQL