David Rowley <dgrowleyml@gmail.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.
regards, tom lane