[teiid-issues] [JBoss JIRA] (TEIID-3992) Improve performance of pg system tables

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13172017#comment-13172017 ] 

Steven Hawkins commented on TEIID-3992:
---------------------------------------

The approach here was to add the parent uid to some of the system tables so that the parent oid could be determined without a join/subquery.  Beyond that the mat_pg_attr table was complete removed as we could go directly against sys.columns which is effectively indexed against the schema/table name.

> Improve performance of pg system tables
> ---------------------------------------
>
>                 Key: TEIID-3992
>                 URL: https://issues.jboss.org/browse/TEIID-3992
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: ODBC, Query Engine
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.0
>
>
> Once materialization is removed from the pg catalog tables performance can be an issue.  At least for the common metadata queries issued with every request.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)