Re: Performance of lateral join

2021-07-29 Thread Simen Andreas Andreassen Lønsethagen
>Easy first question: is the temp table analyzed before being used in a > join ? No, I haven't done that. Today, I tried to run ANALYZE records_to_filter_on; on the same sample data set (3.75 million rows) before the join, and it did not seem to make much of a difference in terms

Performance of lateral join

2021-07-26 Thread Simen Andreas Andreassen Lønsethagen
Hi, first time posting, hope I have included the relevant information. I am trying to understand the performance of a query which is intended to retrieve a subset of the following table: Table "contracts.bis_person_alle_endringer" Column | Typ