pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.

pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.

pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.

pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.

pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.

pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.

pgsql: Rotate instead of shifting hash join batch number.

2019-12-23 Thread Thomas Munro
Rotate instead of shifting hash join batch number. Our algorithm for choosing batch numbers turned out not to work effectively for multi-billion key inner relations. We would use more hash bits than we have, and effectively concentrate all tuples into a smaller number of batches than we intended.