Comment 5 for bug 1931737

Revision history for this message
Mike Rylander (mrylander) wrote :

Hi Michele (and anyone else experiencing this issue), can you provide the output of the queries below? And, did you upgrade straight to 3.7.2, or were you on 3.7.1 or 3.7.0 before that? Versions prior to 3.7.2 had an issue that would bloat certain data and lead to the possibility for this symptom, and the fix for that is to use the newer symspell side loader to reload the dictionary after upgrading to 3.7.2.

Thanks!

-- Queries of interest
select count(*) from search.symspell_dictionary;
select pg_size_pretty(pg_table_size('search.symspell_dictionary'));
select pg_size_pretty(pg_relation_size('search.symspell_dictionary'));
select pg_size_pretty(pg_relation_size('search.symspell_dictionary_pkey'));