backend/server/handlers/config/rhn_config_management.py | 8 ++++++--
backend/spacewalk-backend.spec | 6 +++++-
rel-eng/packages/spacewalk-backend | 2 +-
3 files changed, 12 insertions(+), 4 deletions(-)
New commits:
commit aed4e55bdca8673a1d4dc200bdd71628a3f69464
Author: Aron Parsons <parsonsa(a)bit-sys.com>
Date: Wed Nov 23 15:29:55 2011 -0500
Automatic commit of package [spacewalk-backend] release [1.6.42-1].
diff --git a/backend/spacewalk-backend.spec b/backend/spacewalk-backend.spec
index a63e8d2..3da7a2f 100644
--- a/backend/spacewalk-backend.spec
+++ b/backend/spacewalk-backend.spec
@@ -12,7 +12,7 @@ Name: spacewalk-backend
Summary: Common programs needed to be installed on the Spacewalk servers/proxies
Group: Applications/Internet
License: GPLv2 and Python
-Version: 1.6.41
+Version: 1.6.42
Release: 1%{?dist}
URL:
https://fedorahosted.org/spacewalk
Source0:
https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -675,6 +675,10 @@ rm -f %{rhnconf}/rhnSecret.py*
# $Id$
%changelog
+* Wed Nov 23 2011 Aron Parsons <parsonsa(a)bit-sys.com> 1.6.42-1
+- improve performance of query_client_get_file on PostgreSQL (parsonsa@bit-
+
sys.com)
+
* Wed Nov 23 2011 Jan Pazdziora 1.6.41-1
- Need to name a subselect.
diff --git a/rel-eng/packages/spacewalk-backend b/rel-eng/packages/spacewalk-backend
index d0b230f..1bababb 100644
--- a/rel-eng/packages/spacewalk-backend
+++ b/rel-eng/packages/spacewalk-backend
@@ -1 +1 @@
-1.6.41-1 backend/
+1.6.42-1 backend/
commit 1e64dc4546d96c58dd84a88c3c634b2d2ce164a4
Author: Aron Parsons <parsonsa(a)bit-sys.com>
Date: Wed Nov 23 15:27:22 2011 -0500
improve performance of query_client_get_file on PostgreSQL
use a nested query to join the rhnChecksumView instead of a left join,
which was terribly slow on PostgreSQL because it was doing a sequence
scan instead of an index scan on rhnChecksumView, which has millions of
rows
diff --git a/backend/server/handlers/config/rhn_config_management.py
b/backend/server/handlers/config/rhn_config_management.py
index f65b98e..8eebd93 100644
--- a/backend/server/handlers/config/rhn_config_management.py
+++ b/backend/server/handlers/config/rhn_config_management.py
@@ -196,8 +196,12 @@ class ConfigManagement(configFilesHandler.ConfigFilesHandler):
rhnConfigRevision cr
left join rhnConfigContent ccont
on cr.config_content_id = ccont.id
- left join rhnChecksumView c
- on ccont.checksum_id = c.id,
+ left join
+ (select cs.id, cs.checksum_type, cs.checksum
+ from rhnChecksumView cs
+ inner join rhnConfigContent ccont
+ on ccont.checksum_id = cs.id) c
+ on c.id = ccont.checksum_id,
rhnServerConfigChannel scc,
rhnConfigFile cf,
rhnConfigFileType cft,