]> git.evergreen-ils.org Git - Evergreen.git/commit
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:36:30 +0000 (14:36 -0400)
commit1fcfe59a61931c1b7a99b8785fcc40cac6940098
treed51cf86981f244bdd9b8f1fa2d9afd33515e2b61
parentec80ae0f14d4454fbc39c7724e7e0b61dccce7fa
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
Open-ILS/src/sql/Pg/002.functions.config.sql
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/110.hold_matrix.sql
Open-ILS/src/sql/Pg/300.schema.staged_search.sql
Open-ILS/src/sql/Pg/pgmemcache-ou_tree_traversal_cache.sql
Open-ILS/src/sql/Pg/upgrade/0549.unnest_oils_xpath_table.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0550.unnest_biblio_extract_metabib_field_entry.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0551.unnest_metabib_remap_metarecord_for_bib.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0552.unnest_biblio_map_authority_linking.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0553.unnest_action_hold_request_permit_test.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/0554.unnest_search_query_parser_fts.sql [new file with mode: 0644]