Re: Using regexp from table has unpredictable poor performance

2021-08-25 Thread Jack Christensen
at 4:05 PM Justin Pryzby wrote: > On Wed, Aug 25, 2021 at 11:47:43AM -0500, Jack Christensen wrote: > > I have items that need to be categorized by user defined matching rules. > > Trusted users can create rules that include regular expressions. I've > > reduced the proble

Using regexp from table has unpredictable poor performance

2021-08-25 Thread Jack Christensen
I have items that need to be categorized by user defined matching rules. Trusted users can create rules that include regular expressions. I've reduced the problem to this example. Table "public.items" Column │ Type │ Collation │ Nullable │ Default ┼─┼───┼