Andrew Gierth <and...@tao11.riddles.org.uk> writes: > All the regexp functions blow up with "invalid memory alloc request" > errors when the input string exceeds 256MB in length. This restriction > does not seem to be documented anywhere that I could see.
> (Also for regexp_split* and regexp_matches, there's a limit of 64M total > matches, which also doesn't seem to be documented anywhere). > Should these limits: > a) be removed Doubt it --- we could use the "huge" request variants, maybe, but I wonder whether the engine could run fast enough that you'd want to. > c) have better error messages? +1 for that, though. regards, tom lane