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.