Re: Performance of lateral join

2021-07-26 Thread Justin Pryzby
On Mon, Jul 26, 2021 at 01:56:54PM +, Simen Andreas Andreassen Lønsethagen wrote: > To create the subsets, I (or rather my application) will receive lists of > records which should be matched according to some business logic. Each of > these lists will be read into a temporary table: Easy f

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