Re: Undocumented(?) limits on regexp functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Undocumented(?) limits on regexp functions
Date
Msg-id 7657.1534204151@sss.pgh.pa.us
Whole thread Raw
In response to Undocumented(?) limits on regexp functions  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: Undocumented(?) limits on regexp functions
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Undocumented(?) limits on regexp functions
Next
From: Nico Williams
Date:
Subject: Re: NetBSD vs libxml2