Details

    • Type: Quality Risk
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 11.1.2, 12.0, 11.2.1
    • Component/s: ODBC
    • Labels:
      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  shawkins Steven Hawkins
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: