Project

General

Profile

Bug #7987

Updated by Janos Mattyasovszky over 8 years ago

The pgsql query <pre>select "select count(*) from (select xpath('/entry/*[@fileFormat=<?>]',data) AS x from eventlog) as Y where array_upper(x, 1) > 0</pre> 0" takes too long if you have 300k+ entries. 

 Server: SLES11 SP3 // postgresql91-server-9.1.18-0.3.1 

 This is also heavily impacted by the fact, that the script /opt/rudder/bin/rudder-upgrade, that contains this statement, is run twice on a single-server installation: 

 A 3.0.11->3.0.13 update took: 
 <pre> 
   rpm rudder-inventory-ldap: 61 minutes 
   rpm rudder-webapp:           61 minutes 
 </pre> 

 This could been solved if you would: 
 * Save each type of update that is not required, because it has been checked during any previous update. 
 * Execute this kind of maintenance by the jetty in an async job, not during the RPM installation.

Back