On 6/10/24 13:59, Vitaliy Litovskiy wrote:
2.2 unnest is removed. it is not really needed for this particular data
but this query is autogenerated and unnest makes sense for other data
2.3 "order by token" is uncommented, this is my current way of fixing
the problem I would really appreciate s
On 6/10/24 13:59, Vitaliy Litovskiy wrote:
) tbl2 on tbl1.token = tbl2.token Observations:
1. query runs for 4-5 seconds on v16 and less than a second on v15 2. in
v16 it also goes downs to less than a second if 2.1 distinct is removed
2.2 unnest is removed. it is not really needed for this pa
On Mon, Jun 10, 2024 at 3:32 AM Vitaliy Litovskiy <
vitaliy.litovs...@gmail.com> wrote:
> 1. query runs for 4-5 seconds on v16 and less than a second on v15
>
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 th
