Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-5102

Cleaning up expired audit log entries can be slow

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • 3.2.0
    • None
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      When cleaning up expired audit log entries we try to cascade the deletes to child entries, but are missing an index on the foreign key column, which can cause the deletes to be slower than expected. Seen on postgres. This is a background operation, so shouldn't impact normal usage.

      Attachments

        Issue Links

          Activity

            People

              lpater Lukasz Pater
              lpater Lukasz Pater
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: