Comment 7 for bug 1931737

Thanks, Michele.

You're table data is definitely much larger than I'd expect given the prefix key count (by a factor of about 3), but the index size is in the right range. That suggests the initial DYM upgrade step was done with the pre-patched side loader.

Did you apply those patches after the upgrade, or did you install from a git branch made of 3.7.2 plus those patches, or some other way? I ask because if you loaded the symspell dictionary using the base 3.7.2 code, you'll definitely want to reload it with the patched script and functions in place. That's safe assuming a quiescent database for the rewriting part. You can use the same "export -> process -> unlogged -> truncate -> SQL import -> logged" that was requested at upgrade time, just with the new code, and follow up with an ANALYZE on the dictionary table.

You can also try using CLUSTER to shrink the table data size, if it's not suffering from the pre-patch issues.