On Thu, 20 Aug 2026 at 16:43, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> David Rowley <dgrowleyml(at)gmail(dot)com> writes:
> > Another way to make the alternative join order less favourable would
> > be with something like:
>
> > select count(*) from tenk1 t1 inner join tenk1 t2 on t1.ctid = t2.ctid
> > where t2.ten = 0;
>
> Sure, that'd work for me.
Thanks. I pushed that to all supported versions.
David