Bug 1418174

Summary:	Errata Update takes longer time @scale
Product:	Red Hat Satellite	Reporter:	Pradeep Kumar Surisetty <psuriset>
Component:	Errata Management	Assignee:	John Mitsch <jomitsch>
Status:	CLOSED DUPLICATE	QA Contact:
Severity:	urgent	Docs Contact:
Priority:	urgent
Version:	6.2.6	CC:	bbuckingham, cduryee, jcallaha, jhutar, jomitsch, mmccune, pmoravec
Target Milestone:	Unspecified	Keywords:	Performance, Triaged
Target Release:	Unused
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2017-02-28 16:21:57 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Pradeep Kumar Surisetty 2017-02-01 05:49:12 UTC

Description of problem:

Started errata with 2500 applicable  hosts  (has 6k nodes in setup)
It took 30+ mins to initiate errata on 650 nodes.  


number of transactions processed by server 
one transaction can have 0 - more queries. 

postgres=# SELECT sum(xact_commit+xact_rollback) FROM pg_stat_database;
   sum    
----------
 57422892
(1 row)




Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. Start errata on 2k nodes
2.
3.

Actual results:


Expected results:


Additional info:

Comment 2 John Mitsch 2017-02-23 14:14:49 UTC

Created redmine issue http://projects.theforeman.org/issues/18644 from this bug

Comment 3 John Mitsch 2017-02-28 16:21:57 UTC

This looks to be a duplicate of https://bugzilla.redhat.com/show_bug.cgi?id=1288152

*** This bug has been marked as a duplicate of bug 1288152 ***