Ron Mayer <rm_pg@xxxxxxxxxxxxxxxxxxxxxxx> writes: > Would another possible condition for considering > Cartesian joins be be: > * Consider Cartesian joins when a unique constraint can prove > that at most one row will be pulled from one of the tables > that would be part of this join? What for? That would still lead us to consider large numbers of totally useless joins. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
