From: Tom Lane <t...@sss.pgh.pa.us> Sent: Thursday, April 15, 2021 17:00 To: Daniel Westermann (DWE) <daniel.westerm...@dbi-services.com> Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org> Subject: Re: Strange behavior once statistics are there >I'd suggest trying to flatten these to be regular joins, ie >try to bring up persons6_ and stufen7_ into the main JOIN nest. >It looks like persons6_.pes_id might be unique, meaning that you >don't really need the IN behavior in the first case so flattening >it should be straightforward. The other one is visibly not unique, >but since you're using "select distinct" at the top level anyway, >getting duplicate rows might not be a problem (unless there are >a lot of duplicates?)
Thank you, Tom
