Search Format Reingest from 1252 DB Upgrade Is Slow

Bug #1955154 reported by Jason Stephenson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Undecided
Unassigned

Bug Description

Evergreen version: 3.5.3 upgrading to 3.7.2
PostgreSQL version: 10

While running an upgrade from 3.5.3 to 3.7.2, the script spent over 20 hours on the partial reingest for the 1252 DB upgrade script. The reingest can be greatly sped up (down to 6 minutes from 20+ hours in my example) by using the SQL at this Pastebin; https://pastebin.com/k9YChekC

Tags: database
Lynn Floyd (lfloyd)
Changed in evergreen:
status: New → Confirmed
summary: - Search Fromat Reingest from 1252 DB Upgrade Is Slow
+ Search Format Reingest from 1252 DB Upgrade Is Slow
tags: added: database
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.