Bug 535708 (RHQ-2376) - improve compression / purge performance by creating appropriate indexes
Summary: improve compression / purge performance by creating appropriate indexes
Keywords:
Status: CLOSED NEXTRELEASE
Alias: RHQ-2376
Product: RHQ Project
Classification: Other
Component: Database
Version: unspecified
Hardware: All
OS: All
high
medium
Target Milestone: ---
: ---
Assignee: Joseph Marques
QA Contact: Corey Welton
URL: http://jira.rhq-project.org/browse/RH...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-08-21 23:01 UTC by Joseph Marques
Modified: 2009-09-10 14:51 UTC (History)
0 users

Fixed In Version: 1.3
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed:
Embargoed:

Attachments (Terms of Use)

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
Note You need to log in before you can comment on or make changes to this bug.