java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit c529c7ea18211e9b5f0ee95469625893d9f8e30e
Author: Jonathan Hoser <jonathan.hoser(a)helmholtz-muenchen.de>
Date: Tue Aug 23 12:01:19 2011 +0200
make the taskomatic cleanup delete faster for Postgresql
there's no improvement for Oracle
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
index 051e597..b4254be 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
@@ -294,8 +294,9 @@ SELECT id, channel_label, client, reason, force, bypass_filters,
next_action
<write-mode name="taskomatic_package_changelog_cleanup">
<query params="">
+<!-- DISTINCT makes the DELETE faster for postgresql (no difference for oracle)
-->
DELETE FROM rhnPackageChangeLogData
- WHERE id NOT IN ( SELECT changelog_data_id FROM rhnPackageChangeLogRec )
+ WHERE id NOT IN ( SELECT DISTINCT changelog_data_id FROM rhnPackageChangeLogRec
)
</query>
</write-mode>
Show replies by thread