Bug 535708 (RHQ-2376)

Summary:	improve compression / purge performance by creating appropriate indexes
Product:	[Other] RHQ Project	Reporter:	Joseph Marques <jmarques>
Component:	Database	Assignee:	Joseph Marques <jmarques>
Status:	CLOSED NEXTRELEASE	QA Contact:	Corey Welton <cwelton>
Severity:	medium	Docs Contact:
Priority:	high
Version:	unspecified	Keywords:	Improvement
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	All
URL:	http://jira.rhq-project.org/browse/RHQ-2376
Whiteboard:
Fixed In Version:	1.3	Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Joseph Marques 2009-08-21 23:01:00 UTC

analysis shows single-column indexes on time_stamp speeds stuff up.  need to create on appropriate tables.

Comment 1 Joseph Marques 2009-08-22 00:01:36 UTC

rev4978 - create time_stamp indexes on 1h and 6h measurement tables to speed up compression / purge intervals;

Comment 2 Joseph Marques 2009-09-03 07:53:09 UTC

rev5087 - create time_stamp indexes on raw, 1h, and 6h measurement tables to speed up compression / purge intervals;

Comment 3 Corey Welton 2009-09-10 14:51:50 UTC

QA Closing - code change.

Comment 4 Red Hat Bugzilla 2009-11-10 21:03:11 UTC

This bug was previously known as http://jira.rhq-project.org/browse/RHQ-2376