LP#1998363: Reduce churn caused by bib updates user/miker/lp-1998363-less-ingest-churn-mfe-edition
authorMike Rylander <mrylander@gmail.com>
Thu, 1 Dec 2022 22:23:04 +0000 (17:23 -0500)
committerMike Rylander <mrylander@gmail.com>
Thu, 1 Dec 2022 22:23:04 +0000 (17:23 -0500)
commitc26de2d0a8ac6f57a3929878027230f6515fcae0
treea4a29c929ad954d8884fc81a83fdf313a43742ed
parente7acf4a00c3948fac5f270926c3838459d57434e
LP#1998363: Reduce churn caused by bib updates

This commit causes reingest of the core search data to check for
prexisting values that match exactly after pre-storage normalizers are
run.  When such rows exist, it is reused and rewritten so that changes
to post-storage normalizer configuration will have the intended effects.

This will have downstream benefits for the symspell subsystem that
supports the Did You Mean functionality, allowing it to avoid
reprocessing rows where the data to be processed has not changed in a
way material to that logic.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.metabib_field_entry_churn_reduction.sql [new file with mode: 0644]