From 534eb91cf6592407dd6ee462041922efd678c7cf Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 5 Nov 2021 16:21:09 -0400 Subject: [PATCH] final update to release notes for 3.8.0 Signed-off-by: Galen Charlton --- docs/RELEASE_NOTES_3_8.adoc | 73 ++++++++++++++++++++++++++++++++++++- 1 file changed, 72 insertions(+), 1 deletion(-) diff --git a/docs/RELEASE_NOTES_3_8.adoc b/docs/RELEASE_NOTES_3_8.adoc index ae0c8097e1..41963852db 100644 --- a/docs/RELEASE_NOTES_3_8.adoc +++ b/docs/RELEASE_NOTES_3_8.adoc @@ -3,7 +3,7 @@ :numbered: :toclevels: 3 -== Evergreen 3.8-beta == +== Evergreen 3.8.0 == === Upgrade notes === @@ -52,6 +52,77 @@ CREATE TABLE auditor.backup_usr_alert_msg AS WHERE alert_message IS NOT NULL; ---- +==== Reindexing for Search Suggestions ==== + +The upgrade includes a partial reindexing to update search suggestions. After +running the schema upgrade script, e.g., `version-upgrade/3.7.1-3.8.0-upgrade-db.sql`, +the reindexing can be done as follows. + +First, in a `psql` session connected to your Evergreen database, run: + +[source,sql] +---- +\a +\t + +\o title +select value from metabib.title_field_entry where source in (select id from biblio.record_entry where not deleted); +\o author +select value from metabib.author_field_entry where source in (select id from biblio.record_entry where not deleted); +\o subject +select value from metabib.subject_field_entry where source in (select id from biblio.record_entry where not deleted); +\o series +select value from metabib.series_field_entry where source in (select id from biblio.record_entry where not deleted); +\o identifier +select value from metabib.identifier_field_entry where source in (select id from biblio.record_entry where not deleted); +\o keyword +select value from metabib.keyword_field_entry where source in (select id from biblio.record_entry where not deleted); + +\o +\a +\t +\q +---- + +Then, from the command line: + +[source,sh] +---- +$ ~/EG-src-path/Open-ILS/src/support-scripts/symspell-sideload.pl title > title.sql +$ ~/EG-src-path/Open-ILS/src/support-scripts/symspell-sideload.pl author > author.sql +$ ~/EG-src-path/Open-ILS/src/support-scripts/symspell-sideload.pl subject > subject.sql +$ ~/EG-src-path/Open-ILS/src/support-scripts/symspell-sideload.pl series > series.sql +$ ~/EG-src-path/Open-ILS/src/support-scripts/symspell-sideload.pl identifier > identifier.sql +$ ~/EG-src-path/Open-ILS/src/support-scripts/symspell-sideload.pl keyword > keyword.sql +---- + +Then finally, back in `psql`: + +[source,sql] +---- +ALTER TABLE search.symspell_dictionary SET UNLOGGED; +TRUNCATE search.symspell_dictionary; + +\i identifier.sql +\i author.sql +\i title.sql +\i subject.sql +\i series.sql +\i keyword.sql + +CLUSTER search.symspell_dictionary USING symspell_dictionary_pkey; +REINDEX TABLE search.symspell_dictionary; +ALTER TABLE search.symspell_dictionary SET LOGGED; +VACUUM ANALYZE search.symspell_dictionary; + +DROP TABLE search.symspell_dictionary_partial_title; +DROP TABLE search.symspell_dictionary_partial_author; +DROP TABLE search.symspell_dictionary_partial_subject; +DROP TABLE search.symspell_dictionary_partial_series; +DROP TABLE search.symspell_dictionary_partial_identifier; +DROP TABLE search.symspell_dictionary_partial_keyword; +---- + ==== Updating Reports on Patron Notes ==== The underlying data structure for patron notes has changed with all notes -- 2.43.2