Bug 1470991

Summary:	[RFE] Use materialized views
Product:	[oVirt] ovirt-engine	Reporter:	Martin Perina <mperina>
Component:	Database.Core	Assignee:	Eli Mesika <emesika>
Status:	CLOSED DEFERRED	QA Contact:	Lucie Leistnerova <lleistne>
Severity:	high	Docs Contact:
Priority:	medium
Version:	---	CC:	bugs, lsvaty
Target Milestone:	---	Keywords:	FutureFeature, Performance
Target Release:	---	Flags:	sbonazzo: ovirt-4.4- lsvaty: testing_plan_complete-
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-09-30 13:01:18 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Infra	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1459134
Bug Blocks:

Description Martin Perina 2017-07-14 08:38:51 UTC

Description of problem:

Materialized views [1] can be used to reduce query time on complex queries with low data update rate.

[1] https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.3#Materialized_Views

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


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 2 Martin Perina 2017-10-24 14:10:01 UTC

Moving to 4.3 as we were unable to prove performance improvements using materialized views, on the contrary MVs caused performance degration.