Bug 1470991 - [RFE] Use materialized views
Summary: [RFE] Use materialized views
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Database.Core
Version: ---
Hardware: Unspecified
OS: Unspecified
medium
high
Target Milestone: ---
: ---
Assignee: Eli Mesika
QA Contact: Lucie Leistnerova
URL:
Whiteboard:
Depends On: 1459134
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-07-14 08:38 UTC by Martin Perina
Modified: 2022-03-11 14:45 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-09-30 13:01:18 UTC
oVirt Team: Infra
Embargoed:
sbonazzo: ovirt-4.4-
lsvaty: testing_plan_complete-

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker RHV-45158 0 None None None 2022-03-11 14:45:24 UTC
oVirt gerrit 80334 0 master ABANDONED db: add permissions materialized views 2018-04-08 01:56:21 UTC
oVirt gerrit 80335 0 master ABANDONED db: rename permissions table 2018-04-08 01:56:23 UTC
oVirt gerrit 80336 0 master ABANDONED db: add materialized views refresh SPs 2018-04-08 01:56:26 UTC
oVirt gerrit 80337 0 master ABANDONED db: handle permissions materialized views refresh 2018-04-08 01:56:29 UTC
oVirt gerrit 80338 0 master ABANDONED dao: refresh MV after inserting test data 2018-04-08 01:56:32 UTC
oVirt gerrit 82946 0 master ABANDONED db: adding group permissions views 2018-04-08 01:56:35 UTC

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