Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5533

Improve odbc index metadata query performance

    XMLWordPrintable

Details

    • Quality Risk
    • Resolution: Done
    • Major
    • 11.1.2, 12.0, 11.2.1
    • None
    • ODBC
    • None

    Description

      For a large number of tables/columns the query for pg_index takes an inordinate amount of time to complete - for releases after 10.1.1 this will happen only for the initial load.

      The structure of the query should be improved as well as a managed materialization load to better ensure that it does not block a user query.

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5532 Common table projection minimization does not account for usage in a subquery nested in an aggregate or in some view scenarios

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Resolved
          relates to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5529 Non-pushed subquery may have evaluatable predicates not pushed

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Quality Risk - A potential bug. TEIID-5531 Implicit indexing of common tables doesn't consider composite keys

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: