Re: [HACKERS] Bucket and batch

2008-07-01 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > "Ana Carolina Brito de Almeida" <[EMAIL PROTECTED]> writes: >> So, I would like to know the differences between bucket and batch. > > A bucket is, well, one bucket of a hash table --- it holds all the > tuples that have the same hash code (for as many bits

Re: [HACKERS] Bucket and batch

2008-06-30 Thread Tom Lane
"Ana Carolina Brito de Almeida" <[EMAIL PROTECTED]> writes: > So, I would like to know the differences between bucket and batch. A bucket is, well, one bucket of a hash table --- it holds all the tuples that have the same hash code (for as many bits of the hash code as we are choosing to use). We

[HACKERS] Bucket and batch

2008-06-30 Thread Ana Carolina Brito de Almeida
Hi! I saw that functions which use hash join, like as ExecHashGetBucketAndBatch and ExecScanHashBucket, have bucket and batch concepts. So, I would like to know the differences between bucket and batch. I dont understand tables partitioning mechanism in hash join. Thanks, Ana Carolina