Re: [HACKERS] Effect of caching hash bucket size while costing

2016-12-10 Thread Tom Lane
Robert Haas writes: > On Thu, Dec 8, 2016 at 3:53 AM, Srinivas Karthik V > wrote: >> 1) Can you please let me know if innerbucketsize*innerpathrows captures the >> maximum bucket size? >> 2) why is it not calculated afresh all the time? > Well, #2 is answered there right in the comments: >

Re: [HACKERS] Effect of caching hash bucket size while costing

2016-12-10 Thread Robert Haas
On Thu, Dec 8, 2016 at 3:53 AM, Srinivas Karthik V wrote: > Dear PostgreSQL Hackers, > > I am working in PostgreSQL 9.4.* optimizer module. In costsize.c file and > final_cost_hashjoin() function, the innerbucketsize is either: > > a) calculated using a cached copy >