[PERFORM] self join estimate and constraint exclusion

2017-04-14 Thread Justin Pryzby
I mailed last month [0] but didn't see any reponse .. (if I'm being naive, daft, or missing something simple, please just say so). [0] https://www.postgresql.org/message-id/20170326193344.GS31628%40telsasoft.com It seems when self (inner/equi) joining there's two bad alternatives: either specify

[PERFORM] self join estimate and constraint exclusion

2017-03-26 Thread Justin Pryzby
It seems when self (inner/equi) joining there's two bad alternatives: either specify a where clause for each self-joined table and incur poor estimate and plan, due to incorrect perceived independence of clauses, even though joined column ought to be known equal; or, specify where clause only once,