On Mon, 2023-06-19 at 13:34 +0200, Tomas Vondra wrote: > > > On 6/18/23 22:57, nicolas paris wrote: > > > ... > > > Well, I kinda doubt you have 17023331531230 rows (not even > > > physically > > > possible with 2TB disk), so that's immediately suspicious. > > > > Below is the full plan for the strategy 2.1 (Indeed the previous > > email > > plan was truncated and wrong, sorry for that). > > > > None of the plans has estimates anywhere close to 17023331531230, so > where did that come from? > Well this was an old plan where there was an issue: the david table did not have the same partitioning scheme as goliath. It was partitioned by an other column.
