Re: Undocumented(?) limits on regexp functions

Andrew Gierth <andrew@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