Request a Demo
Home   >   mailing lists

Re: Fix CPU cost of right-semi and right-anti hash joins - Mailing list pgsql-hackers

From wenhui qiu
Subject Re: Fix CPU cost of right-semi and right-anti hash joins
Date
Msg-id CAGjGUA+G3Uo9GMvu_oC-Nv1dfj818SSByAF2y6HRt2Zj2RfOfQ@mail.gmail.com
Whole thread
Responses Re: Fix tuple deformation with virtual generated NOT NULL columns
List pgsql-hackers
Tree view
Hi Richard

> Any thoughts?
The cpu_tuple_cost change looks right: RIGHT_SEMI/RIGHT_ANTI emit
inner-side rows, while hashjointuples is based on the tuples processed
by the hash join and can be much larger. The path LGTM

Thanks 
 
Attachment

pgsql-hackers by date:

Previous
From: Rui Zhao
Date:
Subject: Re: Prove a NOT IN's left-hand expressions non-nullable from quals
Next
From: shveta malik
Date:
Subject: Re: Support EXCEPT for TABLES IN SCHEMA publications