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.
regards, tom lane