Robert Haas <robertmh...@gmail.com> writes: > On Thu, Sep 11, 2014 at 9:59 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: >> Robert Haas <robertmh...@gmail.com> writes: >>> (3) It allows the number of batches to increase on the fly while the >>> hash join is in process.
>> Pardon me for not having read the patch yet, but what part of (3) >> wasn't there already? > EINSUFFICIENTCAFFEINE. > It allows the number of BUCKETS to increase, not the number of > batches. As you say, the number of batches could already increase. Ah. Well, that would mean that we need a heuristic for deciding when to increase the number of buckets versus the number of batches ... seems like a difficult decision. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers