I wrote: > Consider > SELECT count(*) > FROM a FULL JOIN b ON (a.id = b.id) > WHERE (a.x = 42 OR b.y = 43); > and suppose that a and b have mutual FK constraints guaranteeing that > every non-null a.id value has exactly one match in b and vice versa.
Oh, that was sloppy of me. Join removal depends on unique constraints not FK constraints. So actually, this example just requires assuming that both a.id and b.id are known unique, which is much less far-fetched than assuming circular FK constraints. regards, tom lane -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers