projects / evergreen / bjwebb.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 16afbc2) | 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:23:10 +0000 (14:23 -0400)
commit24007bf27d6f53073cfb45e4db43b88f651b971b
tree6b57ef21d13274c45cd6e22c09cf7670ef9de9edtree
parent16afbc211042bec038a15913ee7365690418328bcommit | 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>
14 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/2.0-2.1-upgrade-db.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 (Benjamin Webb)