Brian Hurt <bhurt(at)janestcapital(dot)com> writes:
> Now, the strings that I'm using as the pattern as a regular expression
> really are constant, even if they don't look like it to postgres. Is it
> possible to precompile these expressions (basically, build up the tables
> for the DFA engine ahead of time) in plpgsql?
This already happens internally --- you might need to increase the size
of the cache in src/backend/utils/adt/regexp.c ...
regards, tom lane