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'));
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 symspell_ dictionary; pretty( pg_table_ size('search. symspell_ dictionary' )); pretty( pg_relation_ size('search. symspell_ dictionary' )); pretty( pg_relation_ size('search. symspell_ dictionary_ pkey')) ;
select count(*) from search.
select pg_size_
select pg_size_
select pg_size_