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

Run ANALYZE after index (re-)creation

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      CP: sprint 90
    • Story Points:
      2
    • Development Team:
      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

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases