]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Reduce index bloat involving non-search_field values collab/miker/reduce_index_bloat
authorBob Wicksall <bwicksall@pls-net.org>
Fri, 10 Aug 2012 14:53:11 +0000 (10:53 -0400)
committerMike Rylander <mrylander@gmail.com>
Fri, 10 Aug 2012 14:53:11 +0000 (10:53 -0400)
commit0ba3eb701e780425fc97f1138abd2413f48e6458
treeb19d9df89966e4d1f630971292908a7ab3d1263a
parent4287eca8b84b512beef1b9c742c548ca351e9d70
Reduce index bloat involving non-search_field values

Rows in metabib.title_field_entry, subject_field_entry, series_field_entry,
and author_field_entry are doubled or tripled due to bad logic in
biblio.extract_metabib_field_entry. This results in these tables being 2 or
more times their correct size.

This was introduced in 2.2.0 when the logic for browse_field and facet_field
were added to biblio.extract_metabib_field_entry. 2.1 is not affected.

The duplicates are caused when biblio.extract_metabib_field_entry returns
TRUE in the search_field column for all rows even if they should just be
facet_field or browse_field after the first search_field value is returned.

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.extract_metabib_field_entry.sql [new file with mode: 0644]