From: Tom Lane
Sent: Thursday, April 15, 2021 17:00
To: Daniel Westermann (DWE)
Cc: 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 stufen
"Daniel Westermann (DWE)" writes:
> I currently have a strange behavior once statistics are collected. This is
> the statement (I don't know the application, the statement is as it is):
I think your problem is with the subplan conditions, ie
> and (person1_.id in
>(select persons6_.pe
Hi,
I currently have a strange behavior once statistics are collected. This is the
statement (I don't know the application, the statement is as it is):
explain (analyze, buffers) select distinct standardzi4_.code as col_0_0_,
person1_.personalnummer as col_1_0_,
