pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex

pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex

pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex

pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex

pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex

pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex

pgsql: Avoid quadratic slowdown in regexp match/split functions.

2018-08-28 Thread Andrew Gierth
Avoid quadratic slowdown in regexp match/split functions. regexp_matches, regexp_split_to_table and regexp_split_to_array all work by compiling a list of match positions as character offsets (NOT byte positions) in the source string. Formerly, they then used text_substr to extract the matched tex