<div dir="ltr"><br><div class="gmail_quote"><div dir="ltr"><div style="font-size:large">Materialized Views [1]<span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline"> can be used to reduce query time on complex queries with low data update <br><br></span></div><div style="font-size:large"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline">The first candidates to use this feature are all the *permission* views <br><br></span></div><div style="font-size:large"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline">There is already a RFE [2] opened for that.<br><br></span></div><div style="font-size:large"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline">Please make sure that each call that handles the permissions table data is using the corresponding SP in dbscripts/multi_level_<wbr>administration.sql<br></span></div><div style="font-size:large"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline">No direct access to the permissions table is allowed !<br><br></span></div><div style="font-size:large"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline">In case that a direct access to the permissions table is used, you should replace the code in a call to the corresponding SP as you can see in [3]<br></span></div><div style="font-size:large"><br></div><div style="font-size:large">A direct use that will not be replaced with a call to <span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline">the corresponding SP may cause that direct changes to the permissions table will not be reflected in the  </span><br>*permission* Materialized Views  and the views will remain dirty until a change that is calling one of the SPs that handle the data of the permissions table is issued and cause the Materialized Views to be refreshed <br></div><div style="font-size:large"><br></div><div style="font-size:large">Please check your code for direct use of the permissions table and consult with me if you have any questions or issues.<br><br></div><div style="font-size:large">Thanks<br><br></div><div style="font-size:large">Eli Mesika <br></div><div style="font-size:large"><br>[1] <a href="https://wiki.postgresql.org/wiki/Materialized_Views" target="_blank">https://wiki.postgresql.org/<wbr>wiki/Materialized_Views</a><br>[2] <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1470991" target="_blank">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1470991</a><br>[3] <a href="https://gerrit.ovirt.org/#/c/79287/" target="_blank">https://gerrit.ovirt.org/#/c/<wbr>79287/</a><br></div></div>
</div><br></div>