Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-92048

v7_0_5.UpgradeExpando takes a really long time to complete

    Details

      Description

      Steps to Reproduce: Upgrade with Postgres and millions of records in expandoValue and ExpandoRow tables. The DELETE is rewritten to use NOT EXISTS instead of NOT IN, the query performs MUCH faster in Postgres.

      Expected Behavior: Upgrade would complete in a shorter amount of time

      Actual Behavior: v7_0_5.UpgradeExpando takes a long time to complete

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                summer.zhang Summer Zhang
                Reporter:
                kimberly.chau Kimberly Chau
                Participants of an Issue:
                Recent user:
                Clarissa Velazquez
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  29 weeks ago

                  Packages

                  Version Package
                  7.0.0 DXP FP80
                  7.0.10.11 DXP SP11
                  7.0.X
                  7.1.10 DXP FP10
                  7.1.10.2 SP2
                  7.1.3 CE GA4
                  7.1.X
                  Master