Debloat by removing duplicate metabib index entries user/dbs/reduce_index_bloat
authorDan Scott <dscott@laurentian.ca>
Thu, 16 Aug 2012 03:56:20 +0000 (23:56 -0400)
committerDan Scott <dscott@laurentian.ca>
Thu, 16 Aug 2012 04:01:34 +0000 (00:01 -0400)
commite08677a303067ebc369c408adb9381438187a790
tree055dd067b2c5dabddfd26526cc50abdd5b1dfe0b
parentdeaf96795d2a0793dee1425e2edca1949ba27fc9
Debloat by removing duplicate metabib index entries

The bloaty indexer added rows like so:

 id  | source | field |                                value
-----+--------+-------+----------------------------------------------------------------------
 178 |     47 |     5 | Concertos, piano
 179 |     47 |     5 | Rapsodie sur un thème de Paganini, piano, orchestra
 180 |     47 |     5 | Concertos, piano Rapsodie sur un thème de Paganini, piano, orchestra

Remove all but the last row for every matching source/field rows.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/upgrade/XXXX.function.extract_metabib_field_entry.sql