Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)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