8000 nodes
1,835,447 resources in the population
90% resource duplication
2014-01-22 17:27:39,878 WARN [command-proc-60] [jdbc.internal] Query slower than 10s threshold: actual execution time: 239.6458 seconds; Query: INSERT INTO catalog_resources (catalog,resource,type,
title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalog_resources (catalog,resource,type,title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalo
2014-01-22 17:27:39,997 WARN [command-proc-59] [jdbc.internal] Query slower than 10s threshold: actual execution time: 240.2336 seconds; Query: INSERT INTO catalog_resources (catalog,resource,type$
title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalog_resources (catalog,resource,type,title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalo
2014-01-22 17:27:40,475 WARN [command-proc-57] [jdbc.internal] Query slower than 10s threshold: actual execution time: 242.5738 seconds; Query: INSERT INTO catalog_resources (catalog,resource,type$
title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalog_resources (catalog,resource,type,title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalo
2014-01-22 17:27:40,525 WARN [command-proc-58] [jdbc.internal] Query slower than 10s threshold: actual execution time: 242.4271 seconds; Query: INSERT INTO catalog_resources (catalog,resource,type$
title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalog_resources (catalog,resource,type,title,tags,exported,file,line) VALUES (?,?,?,?,?,?,?,?)INSERT INTO catalo
2014-01-22 17:32:15,363 WARN [qtp1975569943-144] [jdbc.internal] Query slower than 10s threshold: actual execution time: 14.5124 seconds; Query: SELECT COUNT(*) AS c FROM (SELECT DISTINCT resource FROM catalog_resources cr, certname_catalogs cc, certnames c WHERE cr.catalog=cc.catalog AND cc.certname=c.name AND c.deactivated IS NULL) r; Query Params:
2014-01-22 17:32:40,647 WARN [qtp1975569943-606] [jdbc.internal] Query slower than 10s threshold: actual execution time: 33.7568 seconds; Query: SELECT COUNT(*) AS c FROM (SELECT DISTINCT resource FROM catalog_resources cr, certname_catalogs cc, certnames c WHERE cr.catalog=cc.catalog AND cc.certname=c.name AND c.deactivated IS NULL) r; Query Params:
2014-01-22 17:32:40,983 WARN [qtp1975569943-142] [jdbc.internal] Query slower than 10s threshold: actual execution time: 32.7759 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
2014-01-22 17:32:41,781 WARN [qtp1975569943-407] [jdbc.internal] Query slower than 10s threshold: actual execution time: 32.0775 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
2014-01-22 17:32:47,840 WARN [qtp1975569943-499] [jdbc.internal] Query slower than 10s threshold: actual execution time: 32.7528 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params:
2014-01-22 17:32:48,008 WARN [qtp1975569943-144] [jdbc.internal] Query slower than 10s threshold: actual execution time: 32.6443 seconds; Query: SELECT COUNT(*) AS c FROM certname_catalogs cc, catalog_resources cr, certnames c WHERE cc.catalog=cr.catalog AND c.name=cc.certname AND c.deactivated IS NULL; Query Params: