projects / evergreen / tadl.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 095c9bf) | patch
Use native unnest() db function instead of explode_array()
authorDan Scott <dan@coffeecode.net>
Tue, 7 Jun 2011 17:52:22 +0000 (13:52 -0400)
committerDan Scott <dan@coffeecode.net>
Tue, 7 Jun 2011 18:28:27 +0000 (14:28 -0400)
commitc4b9bc54d61fccb0c872b8fb62b3b553f27c40d6
treeff0bb3954808626b58f1794974de923242cfc36dtree
parent095c9bf1572fae9584ac18c1a1233d275d08b6f2commit | diff
Use native unnest() db function instead of explode_array()

Per LP 789747, the custom explode_array() database function
was found to generate significantly slower results for searches than
using the native (and equivalent) unnest() array function. Given that
unnest() has been part of PostgreSQL since 8.4 and Evergreen 2.0
requires a minimum of PostgreSQL 8.4, this patch removes the definition
of the explode_array() functions and replaces its usage with unnest().

Signed-off-by: Dan Scott <dscott@laurentian.ca>
13 files changed:
Open-ILS/src/sql/Pg/002.functions.aggregate.sql diff | blob | history
Open-ILS/src/sql/Pg/002.functions.config.sql diff | blob | history
Open-ILS/src/sql/Pg/002.schema.config.sql diff | blob | history
Open-ILS/src/sql/Pg/030.schema.metabib.sql diff | blob | history
Open-ILS/src/sql/Pg/110.hold_matrix.sql diff | blob | history
Open-ILS/src/sql/Pg/300.schema.staged_search.sql diff | blob | history
Open-ILS/src/sql/Pg/pgmemcache-ou_tree_traversal_cache.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/0549.unnest_oils_xpath_table.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/0550.unnest_biblio_extract_metabib_field_entry.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/0551.unnest_metabib_remap_metarecord_for_bib.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/0552.unnest_biblio_map_authority_linking.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/0553.unnest_action_hold_request_permit_test.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/0554.unnest_search_query_parser_fts.sql [new file with mode: 0644] blob
Evergreen working repo (TADL)