Bug 1427610

Summary: [RFE] Convert vim_performance_states table into monthly partition table
Product: Red Hat CloudForms Management Engine Reporter: Thomas Hennessy <thenness>
Component: PerformanceAssignee: John Hardy <jhardy>
Status: CLOSED WONTFIX QA Contact: Dave Johnson <dajohnso>
Severity: high Docs Contact:
Priority: medium    
Version: 5.7.0CC: dmetzger, jdeubel, jhardy, jocarter, myoder, obarenbo, saali
Target Milestone: GAKeywords: FutureFeature
Target Release: cfme-future   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-07-08 11:47:28 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:
Attachments:
Description Flags
modest-sized customer: bloat info for tables routinely too large to be routinely vacuumed without downtime none

Description Thomas Hennessy 2017-02-28 17:32:44 UTC
Description of problem:for customer VMDB's that contain many elements and/or that are mature enough to begin purging tuples, performance and filesystem usage of partitioned tables will be manageable without incurring outages than single large table.


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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 2 Thomas Hennessy 2017-02-28 17:34:14 UTC
Created attachment 1258464 [details]
modest-sized customer: bloat info for tables routinely too large to be routinely vacuumed without downtime