[HACKERS] Re: why postgresql define NTUP_PER_BUCKET as 10, not other numbers smaller

2014-06-09 Thread b8flowerfire
Robert Haas wrote > On Mon, Jun 9, 2014 at 4:06 AM, b8flowerfire < > b8flowerfire@ > > wrote: > > This has come up before. Basically, the problem is that if you reduce > NTUP_PER_BUCKET, the bucket array gets larger, which might reduce the > amount of space availa

[HACKERS] why postgresql define NTUP_PER_BUCKET as 10, not other numbers smaller

2014-06-09 Thread b8flowerfire
When I read the source code about the hashjoin, I was very confused that the postgresql define the NTUP_PER_BUCKET value as 10. Since this value is used to estimate the tuple count in one bucket, is it better if we have a smaller value? I have not done some experiments, but it seems that we could a