Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-637

Run ANALYZE after index (re-)creation

    XMLWordPrintable

Details

    • CP: sprint 90
    • 2
    • Core: Platform

    Description

      See FOLIO-2625 for a detailed description of the problem.
      When an index is created PostgreSQL does not automatically create statistics. By default 10 % of the table plus 50 tuples need to be inserted/updated/deleted to make the autovacuum daemon start an ANALYZE run automatically.

      Task:

      • After index creation and after dropping and re-creating an index run ANALYZE.

      Note: ANALYZE is 10 times faster than VACUUM and sufficient to collect statistics.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-513 hitcount estimation degeneration when upgrading MIS 19.1.2 (fameflower) -> MIS 19.2.0-SNAPSHOT (RMB30)

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Task - A task that needs to be done. RMB-101 consider running analyze , vacuum one time / in a recurring job - expose via admin

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Open

            Activity

              People

                julianladisch Julian Ladisch
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases