Hi,
Do you really need to do select *?
In other words, is it necessary to have all columns in the result?
Michel SALAIS
De : benoit
Envoyé : lundi 12 juin 2023 23:35
À : Chris Hoover
Cc : pgsql-performance@lists.postgresql.org
Objet : RE: Forced to use UNION ALL when having multiple
> I assume 2TO is 2TB?
Yes. 2TB
> I don't understand why you're sharing just a part of the plan
As for the nested loop plan, what I shared is the full plan. Actually
it is repeated many times, since 2M batched by 500 rows. I add it
again:
Merge on goliath_23 ca (cost=2139.75..11077.17 rows=
