v7_0_5.UpgradeExpando takes a really long time to complete

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X
• Fix Version/s: 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
• Component/s: Database Upgrade Framework
• Labels:
  • ee-ts
  • liferay-dxp-70-sp11
  • liferay-dxp-71-sp2
  • liferay-fixpack-de-80-7010
  • liferay-fixpack-dxp-10-7110
  • pt-upgrade-review
• Branch Version/s:
  7.1.x, 7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/69846

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