Re: Distinct performance dropped by multiple times in v16

Yeah, that's a big regression.  Seeing the actual EXPLAIN ANALYZE output for both systems would be very helpful to us. Also nice to see the plan if you do a 

SET enable_incremental_sort=0;

before running the query

I wonder if materializing things might help, something like

with

  x as (select id, unnest(string_to_array(emp,';')) as token, refdate from terr),

  y as (select id, unnest(string_to_array(emp,';')) as token from employee)

select distinct x.id, y.id, refdate from x join y using (token);

(renamed to avoid all those mixed-case quoting)

Cheers,

Greg